I have a Query for Balance sheet which have the below 4 Columns:
Period/Fiscal Year 1
Period/Fiscal Year 2
In the Rows i have Department.
The problem is with the Variance %. The variance % value for some of the department is coming wrongly. Its displaying as 12,040,781,700% which is wrong. This does not happen to a particular department. It varies depending on the input(Fiscal year) i give. If i give some other input, say Feb 2007, this problem comes for some other department. I have checked the formula, it is correct.
Any help on this is appreciated.