Dataview calculation without exclusion

[Nirrain]

Is there a way to make calculations in dataview not result in filtering?

Specifically if I use the simlpe dataview table

table Value, Cost, (Value - Cost) as Profit from [[DIY]]
It will filter out all source files where Value or Cost are empty. If I remove the Profit calculation all files are included

Thanks!

[blacksmithgu]

I'm working on a better fix for this, but you can use default for now: (default(Value, 0) - default(Cost, 0)) as Profit.

[Nirrain]

Thank you, that is a very useful workaround!

Is there a similar simply solution for including a "total per column" calculation without dataviewjs?