query

Tue, 24 Mar 2015 06:58:54 GMT

I have one doubt if i create a chart between the month and expression or GLcode and expression

=if(Particulars='Administration expense',

//+

num(fabs(sum({<[Fiscal Year_GJAHR] = {'$(vMaxYear1)'},Year=, P_RYEAR=,Companyode={'1500'} >}AmountInLC_Actual_PNL)

/10000000),'#,##0.00' )

)//)

it will give 5.65 but if export the same in excel it will give 6.62 .Any body have any idea what is the reason behind it

Re: query

Tue, 24 Mar 2015 07:00:41 GMT

=if(Particulars='Administration expense',

num(fabs(sum({<[Fiscal Year_GJAHR] = {'$(vMaxYear1)'},Year=, P_RYEAR=,Companyode={'1500'} >}AmountInLC_Actual_PNL)

/10000000),'#,##0.00' )

)