Forum Discussion
If statement not working after publishing
I have a simple calculated column as mentioned below: Status_1 IF(Table[MaxDate] = BLANK(), "Uncf", IF(Today() > Table[MaxDate], "PD", "Not PD")) I use this to create a simple table showing ...
Hey Shishir, I tried that and the date is showing as 24/3 which is correct. I also checked to see if the date formate for MaxDate is dd/mm/yyyy. There are 5700 rows in Table and now the report is showing all of them under "Uncf" status and blank for the other two categories.