We have NUMBER(), DECIMAL()... I need PRICE()

[MultiTech]

We have the following functions available to convert data into a specific type:

We also have things like:

• LIST()
• LATLONG()
• LAT()
• LONG()

But we’re missing: PRICE()

I have a need to force something back into a price so I can use it in math.

Thanks for considering!

[Marc_Dillon]

I just noticed yesterday that we’re also missing .
DURATION()

[Steve · Accepted solution]

Price is just Decimal with some implied formatting, it seems to me. What would PRICE() give you that DECIMAL() doesn’t?

[MultiTech]

I guess I haven’t tried

[Price] + [Decimal]

I assumed it wouldn’t work being two different types.

---

Update: they do work together.

[Grant_Stead]

MultiTech_Visions:

two different types.

You just don’t know what you don’t know