When creating a calculated field using the expression editor in the report designer. The division operator only works correctly when the answer is greater than zero (4 / 2 = 2).
Any division that results in a fraction (e.g. 2 / 4) display as .00 when it should display as 0.50.
The format string set on this cell is {0:#.00}"
WORKAROUND
Please enter a decimal point after the value (2./4 instead of 2/4). This also works with table fields.
STATUS
Waiting for fix in a future release of Toad for Data Analysts
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center