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 con...
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])
jdbuchanan71
Super User
Super UserAnonymous
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])