WebI: Previous Function with Condition

[former_member273013]

Hi All,

I need to perform the following calculation: for each row set to 1 if the current and previous 2 consecutive days have flag = N with the customer as a reset dimension (second column).

In the example it is possible to obtain the result as in the "Value" column?

I tried to use the Previuos Function but always consider the lines with flag = Y

Is it possible to perform this calculation ignoring row with flag = Y?

Thanks to all.

Davide

[Tom_N8]

Hi Davide,

Yes, you will then need to change your [Helper] and [Value] variables, depending on the requirement, e.g. if your client needs to see an indicator for 4 consecutive working days with an 'N' Over Stock indicator. Could you mark the answer above as 'Answered' if it meets your requirement, please?

Kind regards,

Tom