3 Replies Latest reply on Aug 23, 2018 7:38 AM by chakradhar kakani

# Calculate New Percentage column by using existing percentage column

Hello Tableau Users,

I'm trying to calculate another Percentage column by using existing percentage column which was calculated using two measure values (attached is the work book)

As you can see conversion % the formula is sum(profit)/sum(sales) which is straight forward now im trying to calculate a significance % column only for EXPOSED row in the data using conversion % column the formula that should be ((Conversion % of exposed - Conversion % of unexposed) / (Conversion % of unexposed)) *100 so i.e. in my workbook it should be like ((42.68 - 42.92) / 42.92)*100  and ((28.94 - 28.92) / 28.92)*100 and so on....

so I have long list of campaign dates and im lookup calculated field for the significance % percentage and use for calculation but not getting there can any one please help me.

• ###### 1. Re: Calculate New Percentage column by using existing percentage column

Hi

see the attached

set to

returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: Calculate New Percentage column by using existing percentage column

is this the numbers you are looking for?

if first() = 0 then

(([Conversion %] - lookup([Conversion %],1)) /  lookup([Conversion %],1)) * 100

end

Michel