Condition does not work
I have one report with 3 key figures: Debit, Credit, Difference. The data type of "Debit" and "Credit" is amount with currency, and "Difference" is a formula: Debit - Credit.
Now I created a condition as: "Difference" not equal to 0. My expected result is to show all the data whose difference <> 0. But the condition does not work in my report, when I run the query it shows "No data applicable". If I deactivate the condition, then all the data are back. I am sure there are many entries whose difference not equal to 0.
Did anybody meet similar issue before? One note is: this query is based on one multiprovider consist of a standard cube and a remote cube.
Any post would be appreciated and thank you all for your time in advance!