OTBI report built is rounding off the Accounted amount column, how to stop it
Hello Chetana,
Can you provide your logical sql and the requirement of the report design.
Example: Use formula with round and test the issue.
sum(round("- Invoice Accounting"."SLA Unrounded Accounted Amount Credit", 2) by "- General Information"."Invoice Number","- Subledger Accounting Journals Details"."Journal Line Number")
Thanks,
Renuka
Hi Renuka,
The issue is , we have not used any rounding function but the GL amount displayed in OTBI report is getting rounded automatically, which we want to avoid.
Chetana
Chetana,
Can you create simple report with few columns and provide the logical sql.
What format do you see for round("yourGLColumn, 2)
I am having the same issue. Did you find the fix?
