Hi Asif
You don't have to involve cost centre in this formulae. Just create a formula with the below syntax. It should work.
As you said, ABC will hold only negative values.
(KF1 < 0 ) * (KF1 * -1) + (KF1)
Regards
Karthik
Hi Asif,
Your formula would be
(((costcenter == 'ABC') * (((FK1 < 0) * (-1))+ ((FK1 > 0) * FK1)))
Analysis:
Condition : If cost centre = ABC and if the value of FK1 is negative than multiply by -1 else FK1
A.) Cost Center = ABC and Value of FK1 is not negative
Formula: (1) * (0+FK1) Result = FK1
B.) Cost Center NE ABC and Value of FK1 is not negative
Formula: (0) * (0+FK1) Result = 0
C.) Cost Center = ABC, FK1 is negative
Formula: (1) * (FK1 + 0) Result: FK1
Thanks,
Krishna
Add comment