Selected Enum price automatically multiplied with quantity

[anonymous]

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]

[anonymous]

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]

)

[anonymous]

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]

)

[anonymous]

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

[Suvrutt_Gurjar]

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]

)

[anonymous]

THANK YOU SO MUCH! Ur amazing!