Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to count no of records (distinct dates) where Exp1 is greater than Exp2 and present that output in a TEXT BOX.
I am able to achieve this in a straight table, by using IF Conditions, and Counting the Flag in the TOTAL row. But what i actually want is, to present this in a text box (Like a KPI).
Count: If($(Exp1) - $(Exp2) > 0, 1, 0)