It does help me, I was able to build a table with the information I need... thank you...
I am guessing that If we need to have a simple field with that whole calculation I need to create a custom SQL and then link it to other tables...
The reason for this is that I need to combine the net number of orders (sold minus cancelled) with other metrics in the same table... (Example: average income = income/number or orders).
My custom SQL could group data according to my need and then just add a column with a 1 (for sold orders) and -1 for cancelled orders.
With that column in place, all I would need to do is a SUM for that column... I will try and let you know if it worked...
Thank you for the follow up.
Could you mark my answer as correct to close this thread at some point.