Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

query

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

1 Reply
Not applicable
Author

=if(Particulars='Administration expense',

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

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

)