Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=if(Particulars='Administration expense',
num(fabs(sum({<[Fiscal Year_GJAHR] = {'$(vMaxYear1)'},Year=, P_RYEAR=,Companyode={'1500'} >}AmountInLC_Actual_PNL)
/10000000),'#,##0.00' )
)