Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
a quick one, where I´m uncertain:
I simply want to sum up two fields inculding (same) set analysis. Normally I do it in this way:
sum( {<[Date.Cal.Year]={2017}>} [FieldA]) + sum( {<[Date.Cal.Year]={2017}>} [FieldB])
Now I saw that this also works:
sum( {<[Date.Cal.Year]={2017}>} ([FieldA] + [FieldB]))
FieldA and FieldB are both from the same (facts) table.
Due to I have a very large data set and complex nested formulas I´d prefer the second version, but I´m uncertain if there could be any differences in the result.
Can anybody confirm whether the two versions are identical or otherwise outline the difference?
Thanks, Thomas
Hi Thomas,
If I am right, Sum(A+B) =! Sum(A)+Sum(B). IF table is same for A and B and we use range sum so it would be fail for those rows which has null records. Range can give us right result for one table but it could be fail somewhere.
Please correct me if I am wrong!
Best,
Rohit