cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation problem when multiplying RESULTLOOKUP

dorselina
Discoverer
0 Kudos

Good morning,

I am currently building an application under SAC Planning. Unfortunately, I'm having a calculation problem.

Why when I multiply a RESULTLOOKUP by another RESULTLOOKUP, I don't get the expected result:

1000 * 50 = 5000

On the other hand, I have 1438.66

However, if I do the addition in the script, I get the expected result:

1000 + 50 = 1050

DATA([d/Account]="Revenue") = RESULTLOOKUP([d/Account]="Price") + RESULTLOOKUP([d/Account]="Quantity")

Could you tell me how to get 5000 (1000 * 50 = 5000)? Are there things to correct in the script?

Best regards,

Accepted Solutions (0)

Answers (2)

Answers (2)

dorselina
Discoverer
0 Kudos

Thank you a lot, you are right. I just tested it, it works. When I go to the most disaggregated data level, I manage to multiply 50*1000 = 50 000. It's a matter of data distribution.

Now, I still want to ensure that at the level of aggregated data, I still manage to do 50*1000 = 50,000, how can I do that? Using SAC's "property" functionality? I heard that we can do that, but I don't know exactly how to do it...

N1kh1l
Active Contributor
0 Kudos

dorselina

Multiplication and division work differently compared to addition and subtraction in SAC. Both multiplication and division work on join concept and join is on all dimension of model. Your report just shows aggregated data and not the leaf member details with all dimension. Your multiplication will work as expected only if both quantity (1000) and Price (50) is stored on same dimension members for other dimensions except the account dimension. for all records where dimensions members are not same multiplication will return 0. So just check how both Quantity and Price data is stored in model.

Br.

Nikhil