cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MindfulMike
Helper II
Helper II

How to format currency in a nested If statement?

Hi All!

 

I have tried for hours and can't figure this out.

 

For a field in my form I have an If statement:

If ( 'Form1'.Mode = FormMode.Edit , Text ( Parent.Default , "[$-en-US]$#,###" )  , varPrice2 )

This means If a gallery item is picked, the form will populate that items info in Edit Mode and if not, and a new form is created with a separate button, then varPrice2 will populate. This part works.

 

Now when I person selects the gallery item it is formatted in currency, when they go to change, say their prices however, the change does not format at all. How can I make the changed price format into currency using my above If statement? 

 

The formula I have for the OnChange property is for the varPrice2 which basically changes the live input to currency format in new formmode:

Set(varPrice2,Text(Value(Substitute(Substitute(DataCardValue2.Text,",",""),"$","")),"[$-en-US]$###,###"))

 

Thanks in advanced!

0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,582)