numeric format of calculated dimension?

[sushil353]

Hi All

I have a calculated a dimention as =aggr((Sum({<DT_TYPE=>}NDFNDR_SUMMARY.TOTAL_DEFECTS)/Sum ({<OP_VERNUM={1},DT_TYPE=>}total<OT_DESCRIPTION> TOTAL_UNITS_PROCESSED)*100)),NDFNDR_SUMMARY.MT_TYPE)

the results are comming as 1.3837418378

but i want the result format as 1.38 means upto 2 decimal point..

how this can be achieved...

Thanks

[IAMDV]

Have you tried using the Num() function? The Num function formats the expression numerically according to the string given as format-code.

Cheers - DV

[Sokkorn]

Hi Sushil,

Let try this:

NUM(
aggr((Sum({<DT_TYPE=>}NDFNDR_SUMMARY.TOTAL_DEFECTS)/Sum ({<OP_VERNUM={1},DT_TYPE=>}total<OT_DESCRIPTION> TOTAL_UNITS_PROCESSED)*100)),NDFNDR_SUMMARY.MT_TYPE)
,'###,###.##')

Regards,

Sokkorn