Calculated cost field in form

[Oakley]

Have a field that will be a value of 1,2,3,or 4.

based on what the user picks.. the value of the cost field should be 

1 - $75

2 - $125

3- $175

4 - $225

i tried it but it needed a currency value.  Any help you can give would be great.  Thanksm!

[Jodie]

Hi Oakley

I'm guessing at the scenario and use case here so apologies if I'm way off.

If you're trying to use this in a calculated field does this work?

CASE 
WHEN [@cbParamVirtual1]=1 THEN 75
WHEN [@cbParamVirtual1]=2 THEN 125
WHEN [@cbParamVirtual1]=3 THEN 175
WHEN [@cbParamVirtual1]=4 THEN 225
END

(replace [@cbParamVirtual1] with your table field)

And then select in the calculated field to format to currency.

If you're trying to get the value on a dropdown field, does the attached option work by setting the value different to the display in the dropdown options?

[autonumber]

Hi! Just to add, if you want to just format the value as currency for display purposes only, you may refer to this link - https://howto.caspio.com/datapages/datapage-components/field-formatting-options/ But if you want the value to be saved in a currency format, I highly suggest setting the datatype of your field to currency. You may check this link - https://howto.caspio.com/tables-and-views/data-types/data-types/#:~:text=Currency-,Currency,-Used for money

[Queso]

Hello @Oakley, is it correct that your cost field's data type is Currency and you would like the value to be shown as $number in the DataPage?