Apologies as I know this is a rookie issue, but I cannot get any of my formulas to work. I have several different formulas that either multiply or divide a field by a specific number. For example Field (which is a number OR a dollar I have had issues with both) needs to be multiplied by 0.5. I have written it as:
=Multiply([Field], 0.5)
Multiply([Field], 0.5)
=Multiply([Field], .5)
=[Field]*0.5
[Field]-0.5
=Multiply([Field], "0.5")
I'm not sure what I am doing wrong I have rewatched and reviewed the formulas training but am unsure of what I am missing. Any help would be appreciated!!
Thank you in advance 🙂
