Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil1989
Contributor
Contributor

two decimals only on summary(Total) row

Hi ,

Thanks in Advance!!!

i am using straight table , and i am calculating average of rows in my summary(total) row , but they want the data in table without decimal places , but in summary row they should be able to see the data with two decimal places.

Thanks,

Sunilkumar

3 Replies
Not applicable

Hi Sunilkumar,

Are you able to provide sample data/qvw file?

Warm regards,

Nish

sunil1989
Contributor
Contributor
Author

Hi Nishant ,

I work on remote desktop , so i am not able to copy from remote to local.

Thanks,

Sunilkumar

prieper
Master II
Master II

you may check for DIMENSIONALITY:

IF(DIMENSIONLITY() = 0, NUM(SUM(MyValues), '#,##0.00'),

IF(DIMENSIONALITY() = 1 ....

Peter