Hello,
Need help with the below problem:
I have a table by the name of service availed, with the below fields & field types.
The service name field in this table is a ref type with the below formula:
select(Service Details[Service ID], and([Pet Size] = [_thisrow].[Booking ID].[Pet Size],[Pet Type]=[_THISROW].[Booking ID].[Pet ID].[Pet Type]))
In the above formula service details is like a database for all the services that are provided.
What I want is that, when I click on Service Name I should be able to select multiple services at the same time. And the total service charge also should change accordingly based on the service chosen.
I know one of the way is to change the Service name to Enum List type & base type as Ref to Service Details table. But when I do that, I have used Service Name as a ref in few formulas like for Service Charge, which stops working.
any(select(Service Details[Service Charge],and([Service Name] = [_thisrow].[Service Name].[Service Name], [Pet Size] = [_thisrow].[Booking ID].[Pet Size],[Pet Type]=[_THISROW].[Booking ID].[Pet ID].[Pet Type]) ))
Anyone can help on this?
If the information required is less, please do tell.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |