Help with Condition Calculation
Posted: Mon Dec 09, 2024 1:28 pm
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.
My working formula is:
Number([InStockItem1DropDown])+Number([InStockChainLen1])
My modified formula that failes is:
'$'+(Number([InStockItem1DropDown])+Number([InStockChainLen1]))
Any help would be greatly appreciated.