Skip to Content
0
Apr 30, 2020 at 01:02 PM

Help please! I'm so confuse with suppress...

56 Views Last edit Apr 30, 2020 at 09:43 PM 3 rev

I'm making a DTR system report with 4 time columns. In and out for morning and afternoon sessions, respectively. The first image is my output applying formula with conditions.

The output without the conditions applied. I was successful in hiding those values I didn't want to show up, but not on suppressing or removing those blank lines.

One of the formula's I made. Works the same with 'else "" ' added.without the single quote.

What I want to do is to remove those blank lines for every column, so that result will line up horizontally(first image). I've done a lot of suppress trials but it's gives the same result. Please need some ideas. Thank you.