hi all,
I am having a revenue column and a 2 calculated columns in a table in framework manager.
To display the value 0 in place of the missing value ,
I click on query item > click on format type >select numbers and then in properties I set decimal place to 2, decimal separator to . and missing value to 0 and then click on ok .
After testing the query subject, the changes are not reflected i.e still showing the blank values.
Thanks in advance.
Formatting rules are applied when executing a report. Publish the package and you will see that it works with a report
Hi Blom,
Thanks for your reply I got it