Forum Discussion
- 100% Showing in Variance %
Hello - Using the measure below, I am getting the following results in my table.
The -100 % values are for periods (days or months) where we do not have any 2020 values yet.
How can constrain this measure to only show the values with actual comparisons data between 2020 and 2019. Not the - 100% values ?
YOY Orders Rcvd Var % = ([2020 Sum of Recvd Orders]-[2019 Sum of Orders])/[2019 Sum of Orders]
Anonymous
Try something like this:
YOY Orders Rcvd Var % = IF ( [2020 Sum of Recvd Orders] = 0, BLANK(), ([2020 Sum of Recvd Orders]-[2019 Sum of Orders])/[2019 Sum of Orders])
1 Reply
Anonymous
Try something like this:
YOY Orders Rcvd Var % = IF ( [2020 Sum of Recvd Orders] = 0, BLANK(), ([2020 Sum of Recvd Orders]-[2019 Sum of Orders])/[2019 Sum of Orders])