4 Replies Latest reply on Nov 7, 2016 8:11 AM by Timothy Vermeiren

# Calculation of  Manufacturer

Hi,

Can anyone let me know how to calculate the below scenario?

I have a manufacturer column which has A & B.I want to calculate Manufacturer 'C' which is difference of A- B.

• ###### 1. Re: Calculation of  Manufacturer

Hi!

You could probably achieve this by creating the following calculated fields (assuming your data is structured in a regular way):

• Value Manufacturer A:
iif([Manufacturer = "A", [Value], 0)
• Value Manufacturer B:
iif([Manufacturer = "B", [Value], 0)
• Value Manufacturer C:
sum([Value Manufacturer A]) - sum([Value Manufacturer B])

The first two calculations will "single out" the values for the manufacturers A and B so you can work with them. The last one will yield the difference of the totals.

Let us know if this is helpful, and if it works with your data.

Cheers,

Timothy

• ###### 2. Re: Calculation of  Manufacturer

Thanks Timothy,

I was able to get the absolute numbersm but unable to get the growth  numbers.