How to truncate a decimal to 2 places of a sum field
Hi Everyone,
Hope all is well,
When exporting the query to excel, a GPA with 2 digit decimal is showing in Excel with 9 digits past the decimal.
Wanted to truncate the decimal to 2 positions in disco.
so did: TRUNC(SUM(Overall Lgpa Gpa),2) bec query is using the sum field
the sum field shows: .89 and the above calc shows .88
i tried putting ROUND around the above like this ROUND(TRUNC(SUM.....))
and got a data type error....
Your ideas and advice would be appreciated, tx.... sandra