DOLLARFR
A decimal price written as a whole part and a fraction of a denominator.
Group: Financial. Compatible with DAX.
Syntax
DOLLARFR ( <decimal_dollar>, <fraction> )| Parameter | Type | Description |
|---|---|---|
decimal_dollar | Number | The price to write with a fraction, such as 1.125. |
fraction | Whole number | The denominator of the fraction: 16 for sixteenths, 32 for thirty-seconds. |
Returns
Number. The price with its fraction written as a numerator after the point.
Remarks
- The opposite of
DOLLARDE: 1.125 in sixteenths is 1 and 2/16, written 1.02. - The fraction is rounded to a whole number and must then be at least 1. A negative price keeps its sign.
Examples
Back to sixteenths and thirty-seconds
EVALUATE
ROW (
"1.125 in 16ths", DOLLARFR ( 1.125, 16 ),
"1.125 in 32nds", DOLLARFR ( 1.125, 32 )
)| 1.125 in 16ths | 1.125 in 32nds |
|---|---|
| 1.02 | 1.04 |