Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Please find attached my excel file and my qvf files.
My question is how can i fill colour into those null value (circle in red below screenshot).
Another question is it possible to change the value '1' into 'Yes'?
Thanks for the help.
if(isnull(measure),red())
=IF(count(Month)=1,'Yes','No')
it will show Yes in place of 1 but handling Null is not working