Puzzled by a CUMULATE formula...

ChrisG532
ChrisG532
in Modeling

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

  • HimanshuRaj
    HimanshuRaj
    Answer ✓

    @ChrisG532

    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!!

Answers

Categories