1 Reply Latest reply on Dec 21, 2016 4:24 AM by Maciek La

    Newbie - Question about percentage difference and Null Values

    Chris Ford

      Rather that explain the problem. Its probably better to see it below. Having problems using the percentage difference column to compare a value between two tables.

       

      In summary, I only want 3 columns in the below and not to show column 2.

       

      And also if there is a null value, can it return zero so the percentage across works?

      Code here - (ZN(SUM([Number of Records])) - LOOKUP(ZN(SUM([Number of Records])), -1)) / ABS(LOOKUP(ZN(SUM([Number of Records])), -1))

       

      Thank you!

       

      Tableau Question.jpg