Hi everyone!
Trying to create a formula to show a 'number' as opposed to text. I need them to be numbers because I need to create a few of these and Sum them in another formula.
Here's what I have so far, these work but they obviously are showing the amounts as text as opposed to numbers.
{@Charge.Formula}
If {Billing_Data22.CPT1} in ['74178'] Then
"$475.00"
else if {Billing_Data22.CPT1} in ['72148','73721'] Then
"$520.00"
else if {Billing_Data22.CPT1} in ['70553','72156'] Then
"$650.00"
Thanks!
Hi Rich,
Change the code to:
If {Billing_Data22.CPT1} in ['74178'] Then
475
else if {Billing_Data22.CPT1} in ['72148','73721'] Then
520
else if {Billing_Data22.CPT1} in ['70553','72156'] Then
650
You can always enable the 'dollar' sign from the toolbar on the top.
-Abhilash
Add a comment