Replacing if with set

[#1]

Hi Guys.

I know how to replace if with set analysis when expression matters only on one variable but how to replace it in this case?

Sum(if(WhStockBalance>=ReservedQty,ReservedQty,WhStockBalance)*UnitCostPrice)

I need to have some fields ignored over selections but i can't figure it out how to convert this expression into set analysis

Thanks

[alexandros17]

Set Analysis doesn't execute a contitional evaluation so I think you cannot change your if condition with set analysis ...

[anbu1984 · Accepted solution]

Replace Field_To_Be_Ignored by your field name

Sum({<Field_To_Be_Ignored=>} if(WhStockBalance>=ReservedQty,ReservedQty,WhStockBalance)*UnitCostPrice)

[Clever_Anjos]

If you need to ignore selections into Field 1

Sum({<Field1=>}if(WhStockBalance>=ReservedQty,ReservedQty,WhStockBalance)*UnitCostPrice)

[Clever_Anjos]

I think you can use RangeMin in order to replace your IF too

Sum({<Field1=>} Rangemin(WhStockBalance,ReservedQty)*UnitCostPrice)

[gsbeaton]

Hi Julius,

You're going to have to do something like:

IF(WhStockBalance>=ReservedQty,

SUM(ReservedQty*UnitCostPrice),

SUM(WhStockBalance*UnitCostPrice)

)

A bit more verbose than you wanted, but should work.

George

[#7]

Wow guys thanks i can ignore now. I will give another question then. Can i combine fields that needed to be ignored and the field value to be selected. For example now i can ignore Field1 and how to set the Field2 value = 1?

[Clever_Anjos]

Sum({<Field1=,Field2={"1"}>} Rangemin(WhStockBalance,ReservedQty)*UnitCostPrice)

[gsbeaton]

Sorry, I missread your original question,  to follow with your subsequent question, yes, you can combine fields to be ignored with ones to be respected.  You do the following

Sum({<Field1=, Field2=, Field3={'Field to filter on'}>}if(WhStockBalance>=ReservedQty,ReservedQty,WhStockBalance)*UnitCostPrice)