Retail Predictive Application Server (MOSC)

MOSC Banner

EOP measure - catch the last position that is not zero

edited Nov 14, 2018 11:00AM in Retail Predictive Application Server (MOSC) 1 commentAnswered ✓

Hi,

I have a EOP measure regarding to outcome values. I would like to set the measure equal to the last populated value, when is equal to zero.

For instance, in this example, I would like to set "105" in the next positions. I have tried to write this calc rule but it didn't help... APy1StkEOPFB = if (CPy1StkEOPFB >0,CPy1StkEOPFB , CPy1StkEOPFB.last_pop)

The reason to have this need is because I am using Auto Position Query in the workbook to show only a few months but this measure is being calculated for the entire calendar. The aggregated value is showing 0 since the last position is 0.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center