2 Replies Latest reply on Sep 20, 2017 12:52 PM by Joe Oppelt

    Help with Calculation field.

    shwetha sarma

      Hello,

       

      I'm looking for help with a calc.

       

      I have 2 parameters called, PWV and Factor(PFA Excel sheet).

       

      I want to come up with a formula for my Sale such that if PWV and Factor combination is so and so and date year is 2017 the sale value should show up.

       

      I want the sale yearly total to be extracted from the parameter.

       

      So, I want to say

      ( if PWV = 1.43 and factor = 16.4 and year(date new) = 2017 then give me 235896 ).

       

      I'm using tableau forecasting and hence I'm unable to calculate the  year end totals using table calc. I also don't have 'Sale' field in my data, hence using 235896  as an int. Please let the sale value be an int and not sum(sales).

       

      please help.