If you have this equation in a tempale:
<<[Decimal Number] * [Price]>>
The output in the report is a decimal number format. But if you use
<<[Price] * [Decimal Number]>>
Then the output is a price formated number
Just for the record, is [Decimal Number] defined as a Number data type?
In this example, [Decimal Number] is a decimal type column
Oh, I see. Its a difference of the number (> 0) of decimal places reflected in the result. Correct?
I was confused by the usage of โnumberโ - which is a value with no decimal places.
Good tip!!
Let me explain it again in a different way
Value in Appsheet
[Decimal] = 10.0
[Price] = ยฃ2.00
In a workflow, the output you get is:
<<[Decimal] * [Price]>> = 20.0
<<[Price] * [Decimal]>> = ยฃ20.00
Thanks for the tip.
Iโll have to keep an eye out for thisโฆ
Very interesting. Should come into use one of these days