BAQ Sub Query No Record replace with Zero

Epicor ERP 10
,
1

I have one baq which has more subqueries when sub querires doesn`t return any record in main query it shows as null value Field i want it to be replace with zero i tried isnull function but not working. kindly help me @josecgomez

2

What does your query layout look like

3

I just did this recently in a calculated field. The below should work fine

(case when {ServiceLevelMask} IS NULL then 0 else {ServiceLevelMask} end)
4

Hello @josecgomez & @cfinley

Thanks for your quick response. this is how my query design looks like, simple i just want to add day count say holiday + casual leave days+ friday leave days = total days since most of the time say holiday count is coming from holiday sub query return no records but i want to replace with zero so that i can calculate total days in main query though there will be no holiday . image for your reference. i tried isnull function but nothing works returns blank only.

1.PNG
1.PNG2390×1004 296 KB

2
22981×282 50.6 KB

5

Use @cfinley’s suggestion in a calc field in your top level query

6

Great that’s worked Fine …I was trying too much of idea this is very simple.

1 Like
7

You can also use the simpler formula like this rather than the case statement if you want to.

ISNULL({ServiceLevelMask},0)

1 Like