HI I'm using the SWITCH/TRUE function to create a Yes /No return on a column that is generating the number of months between to date.
The issue is where between some on the date the number of months is 0 (zero) and some are blank. I can see from filtering the column there are 393 zero's that need to Yes that are currently No, but if I add 0 (zero) to the SWITCH/TRUE function it is returning all of the BLANKS as well.
Any ideas/help appreciated.
The issue is where between some on the date the number of months is 0 (zero) and some are blank. I can see from filtering the column there are 393 zero's that need to Yes that are currently No, but if I add 0 (zero) to the SWITCH/TRUE function it is returning all of the BLANKS as well.
Any ideas/help appreciated.