Selected Enum price automatically multiplied with quantity

[Caps]

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:

 I really appreciate any help you can provide.😊

[Suvrutt_Gurjar]

Based on the details shared, please pull the [Procedure Cost] from the Procedure table into the child table ( where Procedure table ) is referenced.  Please use an expression something like [Procedure ID].[Procedure Cost] to pull the [Procedure Cost] into the child table.

Then you can get the total cost for the procedure by 

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

[Caps]

This works, but I don't want my other [ProcedureID] to be multiplied by [Tooth involved].. 😔

 I want teeth cleaning and whitening to be displayed by their original [Procedure Cost] even if there's [tooth involved] inputted.

[Suvrutt_Gurjar]

IF([Procedure ID]="Extraction",

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

[Procedure Cost]

)

[Caps]

Tried to do this but it disappeared in my form.

 

[Suvrutt_Gurjar]

Please try 

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

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

[Procedure Cost]

)

[Caps]

It says "Cannot compare Ref with List in ([ProcedureID] = LIST("Prcty3","Prcty4","Prcty5","Prcty6"))"

 

[Suvrutt_Gurjar · 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]

)

[Caps]

THANK YOU SO MUCH! Ur amazing!