Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm sure this is a quick fix, but I've made a chart with some data tying out to part numbers; QOH1, Min1, Max1, Sales1.
I want to remove the part numbers (%FEL) that have no data in the columns listed above. I've tried doing purgchar in the script and it didn't work.....not sure if I've made some sort of mistake or is there another way of doing this?
Please see attachment.
Thanks!
I might be over simplifying this, but I checked your data. If QOH1 is null the other columns are null, too. So, if you go into properties and check the Suppress When Value is Null checkbox, the results should be what you're looking for.
HTH,
Jason
I might be over simplifying this, but I checked your data. If QOH1 is null the other columns are null, too. So, if you go into properties and check the Suppress When Value is Null checkbox, the results should be what you're looking for.
HTH,
Jason
Awesome, this is exactly what I needed!
I knew someone with more experience would be able to find a simple solution without me clicking around for 2 hrs.
Thanks a bunch!
Hi Natalie, please close the thread marking correct/helpful responses if you got the resolution.
Thanks,
V.
You're very welcome, Natalie. Glad I could help.
As Vishwarath stated, please close the thread by marking the correct response.
Hope you have a great day!