Getting error for $ expansion variable check in If block
I have variable vTotalCount which will be assigned through input box. I want to check if variable has value then set to variable value but if varibale doesnot hold value then it should be set to default value to 24.
=IF(len(TRIM(vTotalCount))>0 ,vTotalCount,24) - This expression working as expected.
But when I use $ expansion , I am getting an error as below-