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

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! :nerd_face:

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

1 Like

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

3 Likes

I guess I haven’t tried

[Price] + [Decimal]

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


Update: they do work together.

3 Likes

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

3 Likes