
1. Re: Percent difference calculation
Naveen B Oct 10, 2018 6:10 AM (in response to Ryan Pesso)Hi Ryan,
Use the sum for CTR if it is not aggregated in the calculated field like below
IF (ZN(SUM([CTR]))  LOOKUP(ZN(SUM([CTR])), 1)) / ABS(LOOKUP(ZN(SUM([CTR])), 1)) > 0 THEN 'Up'
else 'Down'
END
or
Change the compute using because you are using the table calculation so make sure the your addressing and partitioning is correct for the LOOKUP function to calculate
Hope this helps
Plz mark this answer as correct or helpful to close the thread
BR,
NB

2. Re: Percent difference calculation
Ryan Pesso Oct 10, 2018 6:42 AM (in response to Naveen B)Thanks for the reply!
CTR is a calculation I created that takes (sum of clicks)/(sum of impressions).
When I do SUM or AVG in the Up or down calculation, I get an error that says CTR is already an aggregate.
I know the % dif calculation is correct because I am getting the right numbers.
What do you mean by addressing and partitioning?