Page 1 of 1

Help with Condition Calculation

Posted: Mon Dec 09, 2024 1:28 pm
by rongreen
I have added a condition in the field InStockItem1DropDown which takes its value and adds it to InStockChainLen1 and places the result in a field called Total. That works fine. How do I add a dollar sign in front of the amount?

My working formula is:
Number([InStockItem1DropDown])+Number([InStockChainLen1])

My modified formula that failes is:
'$'+(Number([InStockItem1DropDown])+Number([InStockChainLen1]))

Any help would be greatly appreciated.