cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to give solving priority to calculated measure over account formula in SAC?

Sorro
Explorer
0 Kudos
785

Hello,

I've a calculation (Margin %) that is not performing as expected at parent level (red value):

 

Table.png

The result is being displayed in a calculated measure (at story level) Amount_A+B, which is simply the sum of Amount_A and Amount_B measures. In the other hand, the Margin % it's a formula account. What it's happening it's that in a first step the account formula it's being calculated, and in the second step the sum of the measures is beign performed, obtaining the wrong result. I guess if I change the calculation order (first the sum of measures, then the account formula) it would work well.

 

I've tried changing the structure priority in the model preference, to give priority to measures, but that doesn't affect the result.

Priority.png

Is there something am I missing here?

Thanks in advance.

 

View Entire Topic
N1kh1l
Active Contributor

@Sorro 

You will see the calculation priority here 

N1kh1l_0-1711052813609.png