Hi,
Built a BAQ with a lot of sub-queries and calculated fields.
some cells are returning no data at all, and if I try to do a conditional to show ‘0’ or ‘-’ is not working, already tried using isnull, and other kind of functions and nothing is working, any other ideas?
thanks
isnull() should work.
I did that earlier today. I had a Power Automate Flow that needed it.
BAQ > REST > JSON > Parse > “Create CSV Table”
That CSV step did NOT like nulls when using custom columns.
Edit: To be clear, the isnull needs to be around the null, not inside of it.
So, if SubQuery1 is the null thing, it does you no good to have isnull() there. You’d need it in the calculated field in the top-level (basically).
4 Likes