Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have two columns one measure
a b measure
1 1 34
2 3 45
6 5 56
now ouput like
a b comparision
1 1 34
2 3 0
6 5 0
what i wnt is if a=b i want show measure value
if not i want show 0 value
expression:
=if (a=b, sum(measure), 0)
Try like this expression:
If(a=b, measure, o)
T simple follow any of the sugestion