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

DM Measure expressions ISNULL, Current or Future Periods

edited Apr 17, 2024 2:20AM in Supply Chain Planning and Collaboration 2 comments

Summary:
1) How can I write a measure expression in Demand Plan that will check if the value of another measure is blank or null to make it equal to null. If the other measure has a value then calculate an equation?

New Measure A = IF(Measure B = NULL or BLANK ) THEN NULL ELSE (Measure B + Measure C)

2) How can I write an expression that will check if it is the current period or greater then leave the measure null. If not then calculate an equation?

New Measure A = IF(current period or future periods) THEN NULL ELSE (Measure B + Measure C)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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