I am trying to calculate a field called "WOS" where I have the VBA code as :
.CalculatedFields.Add Name:="WOS", Formula:="IF(( " 4 WK Average"=0),1,"Inventory OH"&"/"&"4 WK Average")Please Login or Register to view this content.
This does not compute and gives syntax error..I am not sure why.I want it that if "Inventory OH"=0 then 0 if 4 Wk Average =0 then 1 else Inventory OH/4 Wk AveragePlease Login or Register to view this content.
Also should I be putting this in the add data field section or somewhere else?
Bookmarks