I am building a dashboard that has detail as shown below.
What I would like to do is create a formula that says if the grand total is less than 0, return 0 else return the grand total.
If I create a formula to give me this as a stand alone measure it 0’s out all the data less than 0 and gives me a total of 3.
The way I was able to get this to work was modifying the Totals Calculation Rules. The issue I have now, however, is that if I want to do math with this measure, it still uses the original sum, not the if statement I used as a specialty total.
Is there a way I can accomplish this?