Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i am facing a situtation in which i have to show upto two values after decimal for a particular row in a pivot table....
if i use num('a','#.#')
it will display all the values after decimal. how can i restrict it to two values only.....
e.g 134.57
try this num(FIELDNAME, '###.#0')