13 Replies Latest reply on Mar 24, 2014 4:58 PM by Ron Silletti

    if statement issue - tableau doesnt read it

    Ron Silletti

      what im trying to say is 'if net quote price is > 0 take the value in that field, but if its equal to 0 then add up the expected prod and expected services fields


      What is wrong with my syntax???     IF([Quote Total Net Price ($000s)] > 0 THEN sum([Quote Total Net Price ($000s)])) ELSEIF ([Quote Total Net Price ($000s)] = 0 THEN  SUM([Quote Product Net Price ($000s)]+[Quote Service Net Price ($000s)])) ELSE END