3 Replies Latest reply on Jun 1, 2016 7:36 AM by msa s

# increment in profit ration (region wise)

I want to see changes at one time (region wise profit ratio increments) using calculated fields

created blow formula can any one help me to resolve this is this formula correct or need to change any thing. I am new to tableau tool.

correct one for single region increment.

IF ATTR([Region]) ="West" THEN [increased profit ratio] *5

ELSE [Profit Ratio correct] END

what if i want to see increment in all regions.

IF ATTR([Region]) ="West" THEN [increased profit ratio] *5

ELSEIF ATTR([Region])= "Central" THEN [increased profit ratio] *2

ELSEIF ATTR([Region])= "South" THEN [increased profit ratio] *1

ELSEIF ATTR([Region])= "North" THEN [increased profit ratio] *10

ELSE [Profit Ratio correct] END

• ###### 1. Re: increment in profit ration (region wise)

what is profit ratio correct  ?

• ###### 2. Re: increment in profit ration (region wise)

sum[(profit)]/sum[(sales)]

• ###### 3. Re: increment in profit ration (region wise)

calculation seems to be valid , increased profit ratio ,what formulae you used for this one, you are increasing the ratio again by multiplying .