You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Failed IF condition is still producing a value that is used by a subsequent ELSEIF function

Accepted answer
in Planning 18 comments


I am using IF/ELSEIF within a fairly tight FIX. The logic is as follows:


IF(@ISMBR("Jan")) perform X calculation in Jan

ELSEIF(@ISMBR("Feb")) perform Y calculation in Feb that relies on an upper-level data intersection in Jan

For some reason, even if the variable is set to Feb and the first IF (for Jan) returns FALSE, the calculation for Feb uses the number that *would have* calculated for Jan (even though it did not actually calculate and store it in the database)

I feel like I am missing something obvious on how to avoid this situation - any thoughts?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!