Hai,
I need help to create this formula in custom field ([ACWP]/[Cost])*100 to avoid #ERROR becoz some of data in cost is value 0..pls assist me
Hai,
I need help to create this formula in custom field ([ACWP]/[Cost])*100 to avoid #ERROR becoz some of data in cost is value 0..pls assist me
TQ so much Tom Boyle..its work nicely.
Does this work?
IIf([Cost]>0,([ACWP]/[Cost])*100,0)