Select highest value

[SCK]

Hi all. I need help on selecting the 2 highest various values. I have attached the input and output for reference. Please help.

[AshleyL · Accepted solution]

@SCK 

The easiest way to do this would be to add a Formula building block between the Filter and the Sort and create a new field using the formula: abs(py amount). You would then sort on that new field instead of the original.

You shouldn't have to change anything else... the only thing you might want to update is the Reporting Table building block and un-check the new field before you use the Render.

[SCK]

Thanks a ton @AshleyL ! really appreciate all the help! 🙂 🙂