topic Re: two decimals only on summary(Total) row in QlikView

two decimals only on summary(Total) row

sunil1989 — Fri, 28 Apr 2017 11:12:49 GMT

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

Re: two decimals only on summary(Total) row

Fri, 28 Apr 2017 11:23:57 GMT

Hi Sunilkumar,

Are you able to provide sample data/qvw file?

Warm regards,

Nish

Re: two decimals only on summary(Total) row

sunil1989 — Fri, 28 Apr 2017 11:28:25 GMT

Hi Nishant ,

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

Thanks,

Sunilkumar

Re: two decimals only on summary(Total) row

prieper — Fri, 28 Apr 2017 12:16:57 GMT

you may check for DIMENSIONALITY:

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

IF(DIMENSIONALITY() = 1 ....

Peter