Forum Discussion

fpavan76's avatar
fpavan76
Regular Visitor
9 years ago

Calculate Grand Total with Conditional

Hi to all, I need a suggest about a measure to calculate grand total with particular condition. I have 3 columns A, B and C I want insert this condition: IF A+B > C then A+B else 0 This formula ...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi fpavan76,

 

what is the error you are having? I have made a small change in the example I have set-up and created 3 measures for A, B and C and added them to the initial measure I created, and the result is still the same in the column it doesn't give me any error.

 

 

This are simple sum measure and without complex data behind, no filter or nothing. What is the error you are getting? What type of measures are you using.

 

Regards,

MFelix

fpavan76's avatar
fpavan76
Regular Visitor
9 years ago

Hi MFelix

 

I've try use your suggestion but I don't know because it work incorrectly.

 

 

 

In attachment you should see the Measure to calculate A,B and C (i.e. Measure A),
Measure with condition,
measure without condition.

 

If you observe the misure with condition the Grand Total is 28, not 30..


Thanks in advance.

Franco