Assign a Group number based on the total dollar value exceeds $500

[peyton-louden]

Hello, I am trying to create a flow that applies a group type of sorts to data that exceeds $500. So in the "taxable" column, if the value exceeds $500 then the excess of 500 (anything over 500) needs to be split into a new column. I am having trouble grasping how to isolate the "excess" dollar amounts and separate the data into a new column. 

I've attached some sample data as reference. 

Thanks!

[jrgo]

Hi @peyton-louden 

Is the below what you're looking for? if so, see expression below screen cap.

IF [Taxable] > 500
THEN [Taxable] - 500
ELSE 0
ENDIF