G
Guest
Hi,
I want to create a calculated field that uses an if to base its calculation
results.
Therefore i have a field called Site which is a text and another field
called materials which is the number of materials.
=if(Site="Mexico", materials*300, materials*2000)
I have tried this and it doesnt compute based on the Site field or at least
the text isnt matching as I have changed the Site to Mexico and it still
calculates based on the 2000 amount. Anyone know why?
Thanks,
Tim
I want to create a calculated field that uses an if to base its calculation
results.
Therefore i have a field called Site which is a text and another field
called materials which is the number of materials.
=if(Site="Mexico", materials*300, materials*2000)
I have tried this and it doesnt compute based on the Site field or at least
the text isnt matching as I have changed the Site to Mexico and it still
calculates based on the 2000 amount. Anyone know why?
Thanks,
Tim