How to omit empty records in a formula field
Choice fields allow you to use "(not empty)" to omit empty groups on a table. Is there a way to achieve the same thing in a formula field? I'm using some formula fields as the main sorting device on some views. Depending on values in other fields, it displays "Go for it" O
5 replies
-
Oops, pressed the enter button! To continue: the formula field displays "Go for it" or nothing, and when I use it to group records, the top group on the table contains all the records that have nothing returned in the formula field. Would be nice to be able to exclude them from view completely.
-
= null
Nick
-
Well I have the null in the formula ...
if 'MAG STAGE' = 3 or ('WEB STAGE' = 3 or ('APP STAGE' = 3 or ('BEV STAGE' = 5 or ('MAG STAGE' = 5 or ('WEB STAGE' = 5 or ('APP STAGE' = 5 or ('BEV STAGE' = 6 or ('M WRITER' = 2 or ('W WRITER' = 3 or ('A WRITER' = 3 or 'B WRITER' = 5)))))))))) then
text("Go for it")
else
null
end... but the field still throws up an empty group at the top.
-
In grouped column header type:
!= null
Nick
-
Ah, brilliant! Works like a dream. Thanks!
Content aside
- 6 yrs agoLast active
- 5Replies
- 2768Views