I have 2 tables: Booking & Service Availed
Booking table has a virtual column by the name of total business. I want the total business to be calculated of only those services whose status is not cancel.
Hence I am using SUM(Select(Service Availed[Total Service Charge], [Status] <> "Cancelled"))
But when I am using the above formula it is giving me a very weird Sum which does not match absolutely.
Solved! Go to Solution.
I got the answer. I was not filtering basis the ID, hence it was just giving me a total of all checked out services.
I got the answer. I was not filtering basis the ID, hence it was just giving me a total of all checked out services.
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |