Selected Enum price automatically multiplied with quantity

Hello again! please help me with this one ๐Ÿ˜ž 

My ProcedureID is ref in my Procedure table where my Procedure Cost came from.

I just wanted to add some solution in my [Total Procedure Cost] column that if I selected one of these ("Bonding", "Extraction", "Denture", "Filling") in my [ProcedureID] (Enum), I want it to automatically multiply with my [Tooth Involved] * [Procedure Cost]. The rest in my [ProcedureID] will display its original cost.

Expected outcome:

1111.png

โ€ƒI really appreciate any help you can provide.๐Ÿ˜Š

Solved Solved
0 8 170
1 ACCEPTED SOLUTION

Sorry for a typo, please test with the following,

Please try 

IF(IN([Procedure ID],  LIST ("Prcty3" , "Prcty4" , "Prcty5" , "Prcty6")) ,

([Procedure ID].[Procedure Cost])* [Tooth Involved],

[Procedure Cost]

)

 
 

View solution in original post

8 REPLIES 8