Bring value from one or another column and then sum the exact values

[clovati]

Region	Col1	Col2	Col3
REGION1	100	200	100
REGION2	100	50	50
TOTAL (sum)	200	250	150

Hi all.

Col3 >>>> if Col1<=Col2 then Col1 else Col2

How can I have the TOTAL (SUM) in Col3 = 150?

By default IF is applied also to totals and then I obtain 200 as Total in col3.

Thank you ALL

[antoniotiman]

Try GetCurrentField(Group) instead of Region in Aggr()

[tyagishaila]

Try it,

Sum(If(Col1<Col2,Col1,Col2)

[Anonymous]

Hi

Please find attached application

Hope it helps!!

[antoniotiman]

Sum(Aggr(RangeMin(Col1,Col2),$(=GetCurrentField(Gruppo))))