Multiply in different conditional

Question

I have a big data below is just a sample:&nbsp;Status | Annual Amount | Paid Amount | Exchange rate | Factor | TotalA&nbsp; &nbsp; &nbsp; &nbsp; | 2400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 2000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 7.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 12&nbsp; &nbsp; &nbsp; &nbsp;| Annual Amount x Exhchange rate x FactorB&nbsp; &nbsp; &nbsp; &nbsp; | 3270&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 620&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 7.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 12&nbsp; &nbsp; &nbsp; &nbsp;| Paid Amount x Exhchange rate x Factor&nbsp;How to write a formaul when Status =A or B then Total = above formula, the result need to show in the same column. Thank you!!!

jennratten · Accepted Answer

Here you are...= Table.AddColumn(Source, "Total", each if [Status] = "A" then [Annual Amount] * [Exchange Rate] * [Factor] else [Annual Amount] * [Exchange Rate] * [Factor], Currency.Type)

Forum Discussion

Multiply in different conditional

1 Reply

Related content

conditional multiply

Multiply conditions return different results

Conditional formatting for difference between bars?

Multiply values in columns (Different tables)

Multiply rows with different value according to condition