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


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

  • HimanshuRaj
    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