[SOLVED] Conditionally adding values to a virtual field based on &variable

Following the order shown on the attached picture, I need help on tracking when the LAST value of PRCNT_FULL goes below 15 and set the remaining of values to 1. This until it finds a new CMPST_SEQ_N.

This is what the data looks like now

This is what the result should look like

This message has been edited. Last edited by: <Kathryn Henning>,

Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats

Posts: 121 | Location: California | Registered: June 19, 2008

Doug

Expert

posted

Hide Post

Do you mean "LAST" as in the LAST value within a sort break? Or as in PREVIOUS value?

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

prodrigu

Platinum Member

posted

Hide Post

Doug,

Its the previous value.

Thanks,
prodrigu

Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats

Posts: 121 | Location: California | Registered: June 19, 2008

Ignored post by prodrigu posted

Show Post

Tony A

Expert

posted

Hide Post

Without being in a position to test this, try something along the lines of the following. It may need a lot of additional work but might give you something to begin with -

NEW_ADDED_FIELD/I1 IF FR_TNK_I NE LAST FR_TNK_I THEN 0 -* Always set a new set to 0 ???
              ELSE IF FR_TNK_I EQ LAST FR_TNK_I AND LAST NEW_ADDED_FIELD EQ 1 THEN 1
              ELSE IF FR_TNK_I EQ LAST FR_TNK_I AND LAST PRCNT_FULL GT 15 THEN 0
              ELSE 0;