Display Number in Dollar() Format

Declare your ri!totalCost as Number(Decimal)

Display value with dollar.txt

@rizviz Have you had a chance to go through the SAIL recipe at forum.appian.com/.../recipe_define_a_simple_currency_component.html

Try this one.

a!floatingPointField(
label: "Total Cost",
labelPosition: "ABOVE",
value: if(isnull(ri!totalCost), "", dollar(ri!totalCost)),
saveInto: ri!totalCost
refreshAfter: "UNFOCUS",
required: true,
validations: {}
)

@ravir93 - yes ri!totalCost is declared as a Number(decimal) PV. Dollar() is a text function, so I'm trying to figure out the best way to display this within a floatingPointField() component

@sikhivahans yes I have read that, I tried the below approach but get data type error when the SAIL form loads saying "Expression evaluation error: Could not find variable 'totalCost'"

a!textField(
label: "Total Cost",
labelPosition: "ABOVE",
value: if(isnull(ri!totalCost), "", dollar(ri!totalCost)),
saveInto: todecimal(save!ri!totalCost),
refreshAfter: "UNFOCUS",
required: true,
validations: {}
)

Hi @kondetiv, I tried that but the dollar sign and decimals are not appearing on in the field.Any other suggestions would be welcome. thanks.

@rizviz Have a look at the above mentioned recipe and see how you can make best use out of the text functions to format the contents as desired. The error you are facing is because of using the incorrect statement as follows:

saveInto: todecimal(save!ri!totalCost)
/*Instead it should be saveInto:todecimal(save!value)*/


Another standard way is to have the type of currency associated with the name of field (Ex: Total cost ($)) or instructions saying that the value entered is in dollars.

@rizviz, in your code snippet incorrect configuration for saveInto.
correct value is
saveInto: a!save(ri!totalCost, todecimal(save!value))

To use a floating point field, you cannot place text "$" within the value portion - we use the method suggested by sikhivahans above, placing "$" in the field label. If you must place the "$" in the value you will have to use a textField, with something like:

load(
local!totalCost: 0,

a!textField(
label: "Total Cost",
labelPosition: "ABOVE",
value: "$" & if(isnull(local!totalCost),0,fixed(local!totalCost,2)),
saveInto: a!save(local!totalCost,todecimal(save!value)),
refreshAfter: "UNFOCUS",
required: true,
validations: {}
)
)

dollar(if(isnull(ri!ss),0,ri!totalCost))