...
Values with more than 20 digits after the Decimal point are truncated by this function.
- Missing values for this function in the source data result in missing values in the output.
- Multiple columns and wildcards are not supported.
- Using a dash as a negative value indicator (e.g. '-###.00') in your formatting string can change values and their data types. For more information, see Supported Numeric Formatting.
D s snippet usage
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String (column reference), function, or Integer or Decimal literal | MyPrice |
...
| Info |
|---|
NOTE: You cannot create number format strings in which a |
...
| D s | ||
|---|---|---|
|
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String | '###.00' |
...
| OrderId | Qty | UnitPrice | SubTotal | Discount | DiscountedTotal | TaxRate | Total |
|---|---|---|---|---|---|---|---|
| 1001 | 5 | 25.00 | 125.00 | 0 | 125.00 | 0.0825 | 135.31 |
| 1002 | 15 | 39.99 | 599.85 | 0.05 | 569.86 | 0.0825 | 616.87 |
| 1003 | 2 | 99.99 | 199.98 | 0.15 | 169.98 | 0.0825 | 184.01 |
| 1004 | 100 | 999.99 | 99999.00 | 0 | 99999.00 | 0.0825 | 108248.92 |
...
See Also
...
| D s also | ||
|---|---|---|
|
