Apologies for brief subject. I have a Profit and Loss report, and when I've only just noticed that the Profit measure that I'm using, which is simply just this:
[Invoices Paid] (sum of all invoices (Income)) - [PO Billed] (sum of all Purchase Orders (costs)) - [Hours Billed] (sum of all Hours Billed (costs))
That looked simple enough and it worked, until I filtered by the month and found a problem, here is the image below:
If there is no invoice, then it is blank, rather than 0, so neither of the costs will be taken away. It does make sense. However, I can't think of a solution as to rectify this problem that I have. If anyone has any suggestions it will be most appreciated.
NOTE: The three measures in profit [Invoices Paid], [PO Billed], [Hours Billed] are just sum of [insert column] measures and nothing more. They are simply just the total of a column and that's it, so for example [Invoices Paid] is this:
Solved! Go to Solution.
@KyleAdam , Based on what I got; try like
coalesce([Invoices Paid],0) - coalesce([PO Billed],0) - coalesce([Hours Billed],0)
@KyleAdam , Based on what I got; try like
coalesce([Invoices Paid],0) - coalesce([PO Billed],0) - coalesce([Hours Billed],0)
Thank you @amitchandak that worked a treat, I've not even heard of the coalesce, very useful.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
360 | |
102 | |
63 | |
50 | |
49 |
User | Count |
---|---|
348 | |
122 | |
83 | |
68 | |
62 |