-
1. Re: How to Hide rows with null values using Calculated Field
Simon RuncAug 14, 2018 8:25 AM (in response to chandrakanth k)
hi Chandrakanth
So one way is to create a formula like this
[Amount NULL]
ZN([Amountinloccurr2])=0
or you could use ISNULL
You can then bring this in and hide the True values. As you are hiding true and not actual vendors, it will be dynamic to any NULL values.
Hope that helps and makes sense.
-
Dynamic Hiding of NULLs.twbx 11.6 KB
-
-
2. Re: How to Hide rows with null values using Calculated Field
Mahfooj Khan Aug 14, 2018 8:46 AM (in response to chandrakanth k) -
3. Re: How to Hide rows with null values using Calculated Field
chandrakanth k Aug 16, 2018 12:56 AM (in response to Mahfooj Khan)Hello Mahfooj Khan,
How did I miss this simple trick. Thank you for you inputs and this worked.
Regards,
Chandrakanth.K
-
4. Re: How to Hide rows with null values using Calculated Field
chandrakanth k Aug 16, 2018 12:57 AM (in response to Simon Runc)Hello Simon,
Thank you for your inputs. This also helped.
Regards,
Chandrakanth.K
-
5. Re: How to Hide rows with null values using Calculated Field
Mahfooj Khan Aug 16, 2018 1:05 AM (in response to chandrakanth k)I guess sometimes it happens with all of us
-
6. Re: How to Hide rows with null values using Calculated Field
Simon RuncAug 16, 2018 1:06 AM (in response to chandrakanth k)
No problem...it all depends if you want to "hide" or "filter". To "hide" you'd use my method, and for Filtering Mahfooj's is the easiest (you could also use my method, and bring the True/False onto the filter shelf...but why add the extra calculation when you don't need to!!)