Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

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 181
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
Top Labels in this Space