two decimals only on summary(Total) row

[sunil1989]

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

[#2]

Hi Sunilkumar,

Are you able to provide sample data/qvw file?

Warm regards,

Nish

[sunil1989]

Hi Nishant ,

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

Thanks,

Sunilkumar

[prieper]

you may check for DIMENSIONALITY:

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

IF(DIMENSIONALITY() = 1 ....

Peter