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!
Is the below what you're looking for? if so, see expression below screen cap.
IF [Taxable] > 500
THEN [Taxable] - 500
ELSE 0
ENDIF