2 Replies Latest reply on Aug 28, 2017 1:15 PM by Indre White

    Limit percentage displayed on calculated field v10.3

    Indre White

      Hi guys,

       

      Not sure if anyone had this issue before, I am using calculated field for variance %, and although the percentages are correct, I want to show maximum 100% or -100%, even if percentage change is 500% - I need to display 100%  as maximum or negative 100%.

      I am using the percent_variance formula  (ZN([Expense PMPM]) - LOOKUP(ZN([Expense PMPM]), -1)) / ABS(LOOKUP(ZN([Expense PMPM]), -1))

      How this can be done in tableau? 

       

      thank you