Originally Posted by
ashraf
Hi accesstos,
What is this function? it is like : if ([Multiplier] = "ClassFactor") is true then -1 else 0
I tested it for 2 elements & is working fine but I've to multiply by (-1) because the results are in negative.
I'll complete the equation & see.
Thank you
That's right ashraf! This expression (not function) multiplies the logical condition ([Multiplier] = "Class Factor"), which result can be 0 or -1, with the value of the corresponding field ([Class Factor]). Only one of all conditions can be TRUE. And yes, I just failed to state that the TRUE condition equivalent to -1.
Therefor, the finally expression can be:
Code:
Result: [Qty]*-[SelFactor]
Or
Code:
Result: [Qty]*ABS([SelFactor])
Good continuing!
John