How to pick the Max value from the column and use it in the Set expression..?

vishalgoud — Wed, 23 Mar 2022 08:38:25 GMT

Got this interesting requirement into my bucket.

attached is the sample data, I have field called Scenario which have values like jan Target, Feb target, Roll 0+12, Roll 1+11 etc.

every month new target will be added and new Roll get updated for the entire set. So now entire set of records available for each roll. but I have to consider the latest Roll into my set expression.

My Roll should pick the updated or latest one, which is Roll 1+11 as per the sample data.

Roll x+y where x is the current month -2 and y is 12-x..

the total sum of x+y should be 12..

It would be really great and helpful if some one provide the logic to achieve it.

Attaching the excel for sample.

@Anil_Babu_Samineni @sunny_talwar @jagan @jonathandienst @swuehl @tresB Any other expert.

please let me know if anything is not clear.

topic How to pick the Max value from the column and use it in the Set expression..? in App Development

How to pick the Max value from the column and use it in the Set expression..?