Discussion Board for collaboration related to QlikView App Development.
I have derived one metrics in report.
Sales growth=(current sales-prev sales)/(prev sales)
In report current and prev values are same. So ideally it should display 0.0%
But it is displaying -0.0%.
There should not be any sign for 0 value.
Please find the attached image.
Thanks in Advance !!!
This is a rounding error from the floating point arithmetic. Use Round() to eliminate:
=Round((current sales-prev sales)/(prev sales), 0.1)