Formatting an integer to a currency

Product Suggestions
1

An easy way to display an integer as a currency with an expression.

Ex: 1274628.38 to $1,274,628.38

2

hello @nspradley, thanks for posting!! I agree that this would be a useful feature.

in the meantime, have you considered using some Data Manipulation to do this conversion?? here’s a quick sample of one way to do this:

Screen Shot 6
Screen Shot 63104×2024 463 KB

Screen Shot 7
Screen Shot 72118×1466 131 KB

3

Is there a way to do something similar within an analytic?

Honestly currency should be a 1st class data type in Tulip, or at least have a NUMBERTOCURRENCY() funtion.

4

I got this far and it’s a valid expression but I’m getting Analysis Failed: Unknown reason or something like that:

'$' + if(len(totext(round(sum(@MRB Inventory Order Value )))) > 3, left(totext(round(sum(@MRB Inventory Order Value ))), len(totext(round(sum(@MRB Inventory Order Value ))))-3) + ',' + right(totext(round(sum(@MRB Inventory Order Value ))), 3), totext(round(sum(@MRB Inventory Order Value ))))

Edit: I’m on LTS 10

5

@stefan, any idea why this analysis would be failing or why it would be throwing that error code?