Check out our Assessment Centre and the Guild's Knowledge CAR and the Soteria Method

Creating Formulas in custom field to avoid #ERROR

2 replies [Last post]
Mefa Planner
User offline. Last seen 31 weeks 2 days ago. Offline
Joined: 19 Jul 2016
Posts: 6

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

Replies

Mefa Planner
User offline. Last seen 31 weeks 2 days ago. Offline
Joined: 19 Jul 2016
Posts: 6

TQ so much Tom Boyle..its work nicely.

Tom Boyle
User offline. Last seen 2 hours 17 min ago. Offline
Joined: 28 Nov 2006
Posts: 122
Groups: GPC Qatar

Does this work?

IIf([Cost]>0,([ACWP]/[Cost])*100,0)