Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have scenario where in have to take the Max of the Previous Buckets calculated in each row for a particular ID i.e LAN No
Lan Bukect No (Expected Calculated Value)
1 0 0
1 4 4
1 1 4
2 0 0
2 7 7
2 3 7
I hope somebody could give me a solution for my problem? The topic is complicated but maybe there exists a solution?
Thanks
Kind regards,
Arun
Hi Arun,
Here you are a possible solution. I can't attach an example file because there is a time out error in the server, so, I have to write the expression.
= rangemax([Bukect No], above(sum([Bukect No])))
Watch out with the order of the data, it's very important.
I hope it helps you.
Regards.
Hi Arun,
Here you are a possible solution. I can't attach an example file because there is a time out error in the server, so, I have to write the expression.
= rangemax([Bukect No], above(sum([Bukect No])))
Watch out with the order of the data, it's very important.
I hope it helps you.
Hi,
Thanks for the solution.
Thanks & Regards,
Arun