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

in Planning 18 comments

Summary:

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

FIX(&PeriodVar)

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.

Register

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