Hi All ,
I need a solution to round off values in the pivot table built via forms. In the attached ppt you would see the average broadvast age field with decimals i want that to be rounded without decimals.
This pivot is built on a query in the same DB , I had tried changing the decimal to ZERO both in the specific query filed + also in the source table but none is working. All data upto the stage of query i had not used average function.
Only in the pivot i had used an average calculation and i am unable to round off.
Need your help !
Thanks in advance