Details for irohunkirohunk has participated in the following threads:
Added by irohunk on 14 May 2021 at 15:59
I followed the instructions and made a calculated column. While creating the tree diagram, I am getting an additional blank value. I checked all the table values, however, there are no balnk values in it.
I am trying to paste the screenshot here but it is not allowing me to paste.
Calculated field formula:
ByThirds = SWITCH(True, [MonthNumber] < 5, "Truffles", [MonthNumber] < 9, "Sprout", "Spot").
I have added this in this calendar table. The values I am getting are:
Sprout - 22558
Truffles - 20763
Spot - 19611
(Blank) - 11483
Please help in resolving this issue.