Forum Discussion

walt20221's avatar
walt20221
Frequent Visitor
4 years ago

Calculation base on multiple criteria

Hi everyone, I need your help with a special case that I am working with.   I need to create a calculation , this is a multiplication base on multiple criteria. 1. I have a table called "tariffs" ...
v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, walt20221 

 

You can try the following methods.

Total Cost = SUM(tariffs[tariff Amount])*SUM(consolidation[Number of services])

If that doesn't solve your problem, can you provide more sample data? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.