Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with n rows and 3 measures.
Measure1 Measure2 Measure3
2 0 $0
1 1 $13
31 42 $433
3 0 $0
How can I use set analysis (or IF) to do this logic
If measure2 is 0, then measure1 will be 0 else if measure2 is > 0, then measure1 is the same.
Try this
=if(measure2=0,0,measure1)
In your case (as I understand it)"even this should work.
=Sign(measure2) * measure1