Topic Options
#16628 - 04/03/09 03:42 PM Gridview - hide rows if zero
HZN Offline
Adagio Enthusiast

Registered: 11/28/06
Posts: 25
Loc: Brunaby, BC
I'm trying to filter to hide the rolls if the cells on column "OELine Item#" are zero. It didn't work using...

IF({OELine Item#}=0,"","")

Your help most appreciated. Thank you!

Top
#16629 - 04/03/09 03:53 PM Re: Gridview - hide rows if zero [Re: HZN]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11570
Loc: Vancouver, BC Canada
If you are creating a filter, all you need is:
{amount field} <> 0

You don't need an IF formula, as that is implied within filters. Note that you are comparing the amount, not the item number itself. Or do you actually want to filter out an item number code equal to zero?
----
If you are creating a calculated column and you want to only print the value if it is non-zero, then you can do this:
IF({amount field}<>0,STRING({amount field},2),"")

This will output a blank instead of a zero.
_________________________
Regards,
Softrak Tech Support

Top
#16632 - 04/03/09 03:55 PM Re: Gridview - hide rows if zero [Re: Softrak Support]
Kate Spontak Offline
Adagio Pro

Registered: 03/23/02
Posts: 10
Loc: New Jersey
If you want to see only the items, not miscellaneous or comment or instruction lines, you can use

{Line Type}="R"
_________________________
Kate Spontak
Stief Group
New Jersey, the Garden State

Top
#16637 - 04/03/09 04:52 PM Re: Gridview - hide rows if zero [Re: Kate Spontak]
HZN Offline
Adagio Enthusiast

Registered: 11/28/06
Posts: 25
Loc: Brunaby, BC
Thanks Softrak Tech Support for the quick reply.

And also thank you, Kate Spontak. The one you gave me is what I wanted.

Have a great weekend!!!

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 84 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14482 Topics
70726 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31