Puzzled by a CUMULATE formula...
Hi All,
I've picked up this formula at work, and I simply do not understand it.
The formula is for the line 'Switchover month', and reports a '1'.
IF CUMULATE(IF Switchover THEN 0 ELSE 1) = 1 THEN 1 ELSE 0
'Switchover' is an unticked Boolean,
The actual month is October in a FY starting in January.
I get the CUMULATE function (I think), and interpret the formula as reading
CUMULATE (0) =1 THEN 1 ELSE 0
Up to now I can only read this as saying 'add together zero periods and if this equals 1 then report 1 else report 0' which doesn't seem right….
Beats me, but not you all I would think! So help here much appreciated.
Thanks, Chris.
Best Answer
-
It reads as CUMULATE (1) =1 THEN 1 ELSE 0 because you mentioned switchover is unticked so if then else will return to 1. Hence, it reports 1 in line item as a result
Cheers!!
0