for example
If([Unit Cost] = ‘ERROR’,50% * [Price Pre-discount],[Unit Cost])
for example
If([Unit Cost] = ‘ERROR’,50% * [Price Pre-discount],[Unit Cost])
50% means 0.5 * value
50% means value / 2
it has nothing to do with the formulas in Easymorph, as it is math)
thank you. I hadn’t put the zero before .5 so receiving an error, now ok. Appreciate the prompt response.