Select Function is not deriving the right SUM

AppSheet AppSheet Q&A
, ,
1

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.

2

I got the answer. I was not filtering basis the ID, hence it was just giving me a total of all checked out services.