{"id":17773,"date":"2026-01-28T05:09:05","date_gmt":"2026-01-28T05:09:05","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=17773"},"modified":"2026-01-28T05:09:06","modified_gmt":"2026-01-28T05:09:06","slug":"how-does-a-performance-ratio-work-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-a-performance-ratio-work-in-idempiere\/","title":{"rendered":"How does a Performance Ratio work in iDempiere"},"content":{"rendered":"\n

In iDempiere<\/strong>, the Performance Ratio<\/strong> screen is used to define a calculation formula<\/strong> that evaluates performance using accounting data. It allows users to build ratios such as percentages, efficiency measures, or comparisons by combining accounts, constants, and other ratios through arithmetic operations. These calculated results are later used mainly in Goals<\/strong> to measure and visualize performance.<\/p>\n\n\n\n

What the Performance Ratio actually does<\/strong><\/h2>\n\n\n\n

The Performance Ratio acts as a formula engine<\/strong>. It does not post accounting entries or store balances by itself. Instead, it tells iDempiere how to calculate a value<\/strong> by reading accounting facts from a specific Accounting Schema<\/strong> and Posting Type<\/strong> (Actual, Budget, etc.).<\/p>\n\n\n\n

The Accounting Schema<\/strong> in the header defines which set of accounting rules and currency<\/strong> the ratio should use. This ensures the calculation reads values from the correct ledger. The Performance Ratio defined here becomes reusable and can be referenced by multiple goals.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

How the Element tab works<\/strong><\/h2>\n\n\n\n

The Element<\/strong> tab is where the actual formula is built. Each line represents one step or component<\/strong> of the calculation, and the system evaluates these lines in sequence.<\/p>\n\n\n\n

Each element defines<\/strong><\/h3>\n\n\n\n
    \n
  • What value to take<\/strong> (account, constant, another ratio, or calculated value)<\/li>\n\n\n\n
  • How to combine it<\/strong> with the previous value using an operand<\/li>\n\n\n\n
  • Which posting type<\/strong> to read from (for example, Actual or Budget)<\/li>\n<\/ul>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    The Operand<\/strong> defines how the current element interacts with the previous result. Available operations are:<\/p>\n\n\n\n

      \n
    • Plus (+)<\/strong> – adds a value<\/li>\n\n\n\n
    • Minus (\u2212)<\/strong> – subtracts a value<\/li>\n\n\n\n
    • Divide (\u00f7)<\/strong> – divides the result<\/li>\n\n\n\n
    • Multiply (\u00d7)<\/strong> – multiplies the result<\/li>\n<\/ul>\n\n\n\n

      This allows complex formulas to be built step by step.<\/p>\n\n\n\n

      Understanding Element Type and Account Value<\/strong><\/h2>\n\n\n\n

      The Element Type<\/strong> determines the source of the value used in the calculation<\/p>\n\n\n\n

        \n
      • Account Value<\/strong> – Reads balances from a selected GL account<\/li>\n\n\n\n
      • Calculation<\/strong> – Uses a calculated value<\/li>\n\n\n\n
      • Constant<\/strong> – Uses a fixed numeric value (for example, 100)<\/li>\n\n\n\n
      • Ratio<\/strong> – Reuses another Performance Ratio inside this formula<\/li>\n<\/ul>\n\n\n\n

        The Posting Type<\/strong> defines whether the value comes from Actual, Budget, or another posting type.<\/p>\n","protected":false},"excerpt":{"rendered":"

        In iDempiere, the Performance Ratio screen is used to define a calculation formula that evaluates performance using accounting data. It […]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[38],"tags":[],"class_list":["post-17773","post","type-post","status-publish","format-standard","hentry","category-master"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=17773"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/17773\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=17773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=17773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=17773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}