Multirow Formula

UmarS

Hi All,

I am trying to solve the below use case. I need to set the target column to 0 if there exists any row with 0 for a particular Deal Name column. Otherwise set the target to the amount value. Thanks for your help.

DEAL_NAME	amount	Target
1	0	0
1	150	0
1	200	0
1	15	0
2	0	0
3	0	0
3	140	0
3	50	0
4	300	0
4	0	0
5	30	30
5	31	31

MarqueeCrew

@UmarS,

I'd go about this a different way.  You can take the incoming data through a SUMMARIZE tool and GroupBy Deal_Name with a MIN on amount.  Join that data back to the incoming data on Deal_Name.

Now you can create a formula with something like:

IIF([min_amount] == 0,0,[amount])

Then use a SELECT tool to remove the min_amount.

I think that it reads cleanly and is easy to maintain.

Cheers,

Mark