Formula

[Sarath27]

Hi All,

Please kindly assist me in calculating column "Final Levelling".

Logic :

There are 6 cumulative counts in the attachment.

i) Threshold limit for all the columns is 6.
ii) Example 1: If a Cumulative Count 1Y < 6, then it should be marked as "Observable to 1Y".
iii) Example 2: If any of cumulative count >6 till the next column value is 0, then we need to mark that as "Observable to "the column it has value more than 6".

[Bren_Spill · Accepted solution]

@Sarath27 - try the formula. You have both "Observable to <1Y" and "Observable <1Y" in your Final Levelling column - I have assumed they are the same in the formula below:

if [Cumulative Count 5Y] > 6 then "Observable to 5Y" elseif
[Cumulative Count 4Y] > 6 then "Observable to 4Y" elseif
[Cumulative Count 3Y] > 6 then "Observable to 3Y" elseif
[Cumulative Count 2Y] > 6 then "Observable to 2Y" elseif
[Cumulative Count 1Y] > 6 then "Observable to 1Y" elseif
[Cumulative Count 1Y] != 0 then "Observable to <1Y" elseif
[Cumulative Count 2Y] != 0 then "Observable to <2Y" elseif
[Cumulative Count 3Y] != 0 then "Observable to <3Y" elseif
[Cumulative Count 4Y] != 0 then "Observable to <4Y" elseif
[Cumulative Count 5Y] != 0 then "Observable to <5Y" else "ERROR" endif

[Sarath27]

@Bren_Spill Amazing solution, it worked. Thanks much, appreciated your prompt response.