Question

Calculations of the Measure Items in BR

  • 10 October 2023
  • 1 reply
  • 22 views
T
Rank
Userlevel 2
Badge +6

Hi,

 

Is there any way to do the calculations like count, max, min using measure items in IFS business reporter? 

As per the point 1, I have dragged debit balance column to the report. After running it will show sum of debit balances of the accounts as per the point 2. I want to get max amount of debit balance for each account.

 

Thank You.

Regards,

Deepal.

 

 

 

1 reply

SandT
Rank
Userlevel 3
Badge +6

Hi @TopDeepaW ,

 

When it comes to calculated functions like Count, Max, Min, I have followed the below approaches based on the report design.

 

  1. Since we can use inbuilt functions of MS Excel when designing BR reports, if there is any possibility to generate the ranges we want to calculate in report design, we will be able to use excel functions to get the required result. And we can hide those ranges from design if they are unwanted.

 

  1. By creating custom attributes for the fact using required functions, we will be able to use them directly in report design.

 

 

Best regards,

SandT

Best Regards, SandT

Reply


Terms & ConditionsCookie settings