Format the query item data not reflecting

[saumil287]

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.

[blom0344]

Formatting rules are applied when executing a report. Publish the package and you will see that it works with a report

[saumil287]

Hi Blom,
Thanks for your reply I got it