Hello,
We appear to have an issue where for a particular metric, when it is exported into Excel, occasionally it will display a value of "0.00" in the column, but when you click on the cell it displays the value in the formula bar in Scientific Notation. It only appears to be happening with two particular formulas..below is one of them (they are both fairly similar):
Formula 1: {AMOUNT_REQUESTED}-{@LaborAndPartsReq}-{@TravelReq}
Sub formula definitions:
@LaborAndPartsReq =
IF ISNULL({LABOR}) THEN
{TOTAL_REQUESTED}
ELSE IF ISNULL({TOTAL_REQUESTED}) THEN
{LABOR}
ELSE
{LABOR}+{TOTAL_REQUESTED}
@TravelReq =
If IsNull({.TRAVEL}) then
0
else
{TRAVEL}
This issue only appears to occurr for certain records and for the most part it works fine. I've tried swapping around the data formats and such but it doesn't appear to fix anything. The values themselves should not be overly large as far as digits go so I'm wondering if it's a negative number thing?
We appear to have an issue where for a particular metric, when it is exported into Excel, occasionally it will display a value of "0.00" in the column, but when you click on the cell it displays the value in the formula bar in Scientific Notation. It only appears to be happening with two particular formulas..below is one of them (they are both fairly similar):
Formula 1: {AMOUNT_REQUESTED}-{@LaborAndPartsReq}-{@TravelReq}
Sub formula definitions:
@LaborAndPartsReq =
IF ISNULL({LABOR}) THEN
{TOTAL_REQUESTED}
ELSE IF ISNULL({TOTAL_REQUESTED}) THEN
{LABOR}
ELSE
{LABOR}+{TOTAL_REQUESTED}
@TravelReq =
If IsNull({.TRAVEL}) then
0
else
{TRAVEL}
This issue only appears to occurr for certain records and for the most part it works fine. I've tried swapping around the data formats and such but it doesn't appear to fix anything. The values themselves should not be overly large as far as digits go so I'm wondering if it's a negative number thing?