You can replace [Core Title Diffference by Weeks #no %] with
if (ABS(SUM( ZN([CORE TITLE (This Week)]*100 ) - ZN( [CORE TITLE (Last Week)] *100) ))) != (SUM( [CORE TITLE (This Week)]*100 ))
then SUM( [Core Title Difference by Weeks # no % ] )
So you return the second value only when there is a difference in the Sum of the two values.
exclude difference mc.twbx 4.3 MB
This is absolutely it, thank you SO much for the quick response! Saved me on this one, couldn't figure it out.