In BAQ, can you return a zero instead of a null?

Epicor ERP 10
1

Hello,

Not really important, just trying to make a BAQ/Dashboard a little more readable to the employees.
I have a BAQ that displays a calculated on-hand qty for parts.
If there has never been a qty put in for the part, it returns a null.
Is there a way to get the BAQ to return a 0 instead (or the dashboard if a BAQ can’t)?
If not, then they will live with it.
Any help is really appreciated.
Thanks,

Shawn

2

Use a calculated field as such

ISNULL(YourField,0)
4 Likes
3

You are the man!

Once I simplified the BAQ to get rid of a feature they decided they didn’t want, it was easy to modify the calculated expression with this.

I appreciate the help.

Thanks,

Shawn

1 Like