Formula to include a field if conditionally.
I currently have 3 fields that i am adding to gether in a formula
[Other Savings Field 2.1]+[Other Savings Field 2.2]+[Other Savings Field 2.3] now if i wanted to add Other savings 1.1 to it c...
Forum Discussion
I am getting an error on the calculation stating expecting text but found a number. Any suggestions on how to fix this?
------------------------------
Kari Lang
------------------------------
Can you confirm if the field [Other Savings Field 1] is a numeric field? It looks like in the scope of the if() statement that it's interpreting that field as text, so if that field type is text then wrap it in a ToNumber field like:
[FTE Reduction Savings2]+[Rework. Final Amount]+[Medical Cost Savings1] + [Automation Savings.1] + if( [Include in Total calculation1], ToNumber([Other Savings Field 1]), 0)
------------------------------
Chayce Duncan
------------------------------