How to hide the entire row when "if" function returns "No Value"?
Content
Hi,
I am using the "if" function to return the value that I need & it works fine but I only want the report to return the output/rows with "No" values & hide entire row for the "No Value."
if(max(transactions.created) >= max(tasks.completed) & date_diff(max(transactions.created), max(tasks.completed)) >=1036800,'No','No Value')
Ideally I want to use "if" function & not to update "else" section with anything but I have to put something to make it work. I tried looking in previous posts but couldn't find anything relevant.
I do not want to use "Auto filter" or "Slice" function. It has to be something that doesn't show to the person running the report or requires action from their end.
Tagged:
1