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

[former_member273013]

Hi Tom,

thank you very much for your support, you have been very professional and kind.

I Accepted you answer.

Best Regards.

Davide

[Tom_N8]

Thank you very much, Davide. I am glad to hear we got there in the end!

Kind regards,

Tom