on 03-21-2024 4:18 AM
Hello,
I've a calculation (Margin %) that is not performing as expected at parent level (red value):
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.
Is there something am I missing here?
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Both Measures & Accounts should be at [created in] the Model Level, not at the Story Level.
And try checking the data[preview] at the Model Level Calculations. If it is the issue at the Model Level, then it should be checked at the Model Level. If it is correct at the Model Level, need to look into the issue at the Story Level. If you feel, it is the issue with product then need to raise ticket to SAP.
Thanks, Siva.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Under structure priority you have custom priority options. Once enabled, In the calculation measure designer section in modeler view, you can set custom priority of various calculated accounts and calculated measures.
Br.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @N1kh1l
I already tried that, but I don't see where I can give custom priority to my account, can you help me with a quick pointing out or a screenshot please?
Thanks
User | Count |
---|---|
78 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.