Skip to Content
0
Former Member
Jun 03, 2009 at 07:47 AM

Variance% value showing wrongly

20 Views

Hi,

I have a Query for Balance sheet which have the below 4 Columns:

Period/Fiscal Year 1

Period/Fiscal Year 2

Variance $

Variance %

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.

Thanks,

Murali