1 of 1 people found this helpful
You are very close to accomplish your needs.
Change the formula to
IF attr([TRENDS]) = "True Drop" OR attr([TRENDS]) = "MoM Dropped" THEN -1 * COUNTD(ID)
Because the measures are aggregated, you also need to aggregate dimensions.
Thank you, Shin! Your explanation makes perfect sense.
Question: I have seen the ATTR() function floating around in a couple instances now. How does it apply aggregation? Is it similar to an oracle STATS_MODE function?
I have no idea about Oracle.
Just in general, under IF statement, in case yes/no judgment is based on line item basis, you don't need to use atrr() .
But the yes/no judgment is based on aggregated value, dimension also needs to be aggregated to that level with attr().