I am using GROUP_DIFF to get some value. But if there is only one row, I don't have a value, but get <error> in red font instead.
So I am trying to convert it to numeric value, but my method below did not work.
IF(T(#sheet1!B) == "<error>";0;INT(#sheet1!B))
What else can I do?
Please sign in to leave a comment.