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.๐
Solved! Go to 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]
)
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |