RegEx to Calculate Conditionals

Question

Dear all,

I trying to create a formula to calculate the 'Amount' based on the variable from 'Qty_Type' :

The rule is:

A = 10

C = 5

I = 0

I need to calculate the (number * letter) + (number * letter) + ...

Could you help me to find the best way to do that?

caltang · Answer

Alternatively....

For FabioP.yxmd

caltang · Answer

I used some sample data, but the idea is like this:

For FabioP.yxmd

caltang · Answer

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.