Forum Discussion
need help calculating yoy difference
I'm trying to not show the diff YOY actual for dates in the future, I tried a if statement but this does not apply to the totals so that it is still calculating across the row. i'd like to sum jus...
CNENFRNL
Community Champion
Community ChampionRows from 2021 Sept are forced to shown because of [PIPELINE LY]; what's more, "" is also a non-blank value to show.
diff YOY Acctual =
VAR __p = [Pipeline] RETURN IF( NOT ISBLANK( __p ), ( __p - [Pipeline ly] ) )
i'm still showing the incorrec sum on that column, not sure why this is happining, it blanks the data correctly but it is still summing across ther row.