See if account falls within % range

Question

Hi Community,

I have multiple rows of records to group according to account number. and if they are the same, i would need to calculate the amount by 1% using the smallest amount and see if they are within 1% range. I am looking at the multi row formula and stuck currently? Any help please?

Eg of few records below

account numberamount12310012315555560077721077721.05

atcodedog05 · Answer

Hi @KLS

Sadly that wont be possible 😅

KLS · Answer

@atcodedog05 hey i realized it works to some extent. Eg for account 777 the min amount is 210 which is not ideal .I need 990 to be the amount  as well. Meaning 210 and 990 to be the min amount for 777.to Is this possible?

accountamountname123100charles123155john555600stones777210jack777210.5jack777990jack777990.5jack

atcodedog05 · Answer

Hi @KLS

Add the column in summarize tool it should work.

Workflow:

Hope this helps : )

1% (1).yxmd