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

Newbie - Question about percentage difference and Null Values

Chris Ford Dec 20, 2016 8:41 AM

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!

1. Re: Newbie - Question about percentage difference and Null Values

Maciek La Dec 21, 2016 4:24 AM (in response to Chris Ford)

q1: it's hard to say without seeing pills you have in header but I assume that you pulled too much try removing unnecessary columns from the view or at least right click > uncheck show header
q2: try wrapping whole calculation with zn()

would be awesome to see .twbx file so we can give you better advice
Like Show 0 Likes(0)

Actions

Tableau Community

Newbie - Question about percentage difference and Null Values

1. Re: Newbie - Question about percentage difference and Null Values

Actions

More Like This