How do I format SOOrder.CuryLineTotal to read like 1,000.00?

All calculated fields do that. Add in CuryLineTotal as a schema field like below and this will resolve your issue.

All calculated fields do that. Add in that CuryLineTotal as a schema field like below and this will resolve your issue.

 

@brendan91 Sorry- how do I do this in a report?

Report designer can be trickier. After an equation, you may need to convert the answer using CInt([table.field]) or CDec([table.field]) and then use the field you want your calculated field to look like in the format line.

If you want a dollar sign, use c instead

@ALEXSLUSSER15 

I use #,##0.00 in the format property like so:

Report designer can be trickier. After an equation, you may need to convert the answer using CInt([table.field]) or CDec([table.field]) and then use the field you want your calculated field to look like in the format line.

If you want a dollar sign, use c instead

 

@brendan91 I tried this but it didn’t work. I think it’s because the value of the text box is an if/then statement. Any ideas on how to format the outcome of this? It’s just an if/then to determine what math should be done.

wrap each of those IIFs in a into a CStr() or CDec() like so...

=CStr(IIF([SoOrder.TermsID]=’5050’,[SoOrder.CuryLineTotal + 0.50, ‘’)) + CStr(IIF(…..)) + CStr(IIF(…..))

Then format =[SoOrder.LineTotal]

I believe that will work...Let us know!

@ALEXSLUSSER15

Just so the solution is clear for the future, you do not need the CDEC in front as the result was already a decimal. The only thing needed is #,##0.00 in the formatting property.

Glad you got it working!

@DConcannon  I believe I’ve trained myself into a bad habit (or an unnecessary habit at best). I had a formula once that I “got working” by converting it to a number and I’ve been converting my formula’s ever since - “to be safe.” Turns out, this was likely unnecessary. 

I just confirmed for myself that Alex’s formula worked without the number conversion. As well as a lot of my own formulas 😏.Thanks