how to conditionally display numeric data in OBIEE
YalaNov 9 2009 — edited Nov 10 2011Hello guys
I have a question about displaying data's decimal places based on conditions
I have one column called "account amount" which as the following data in the DB:
"account amount"
100.09
564.329
400
603.66
80.829
Is there a way I can display these data on the OBIEE report with the exact same display as above? Currently in OBIEE, if I select 3 decimal places in column format, it will then apply to all records, if I select no decimal places, then all the records with decimal places will be rounded up to integer.. Is there a way to conditionally display these records according to its decimal places? In other words, if the record is "400" then display "400" instead of "400.00"; if the record is "100.09" then display "100.09" instead of "100" or something else?
Please let me know your thoughts.