You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to hide the entire row when "if" function returns "No Value"?

edited Jan 4, 2016 4:36PM in Reporting & Analytics for B2C Service 2 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!