By using this website, you agree to our Terms of Use (click here)
Hi
Just doing a simple Dashboard and I have a Company parameter that get's its value from PX.SM.Branch
Now I have the issue, when the value is a Branch then it works
How do I specify "Or the Company Parameter is empty or blank" because I tried a whole lot of ways with zero results.
"Branch" = [Company] OR [Company] = '' OR [Company] Is Null
I'm on around 2021R1 (this isn't pure Acumatica).
Any help appreciated
Thanks
Rich
EDIT:
The idea is to have a dynamic list so don't really want to create a whole bunch of shared filters
Hi All
So I found the reason why this didn't work.
When I created the Dashboard I created the Parameter as Required.
I then created the widgets with the filter.
Then I changed the Parameter to not be required
This caused the issue.
After changing the Parameter to not be required you need to edit the Widget again and just save it. Then the widget will work as expected!
It seems that the widget looks at the parameter when created to see if the parameter is required or not and saves that until the next edit. So if you change the Parameter then you need to edit and save each widget to get the new setting.
Thanks @richard-whight for following up with your solution. I've encountered similar behavior when modifying Generic Inquiry RESULTS GRID formulas that are used by Dashboard Widget filters.
Online Members