0

Nested Filter

Dears,

I have an issue with how Incorta handling the Nested Filters which is working fine when I convert the logic from the DB into other BI tools. But when I applied the same logic it is not working maybe I missed something or if you can help in how should be the syntax in Incorta. 

In DB:

And (   (A.Comp_Id <> -1 And A.EMPid Is Not Null) Or (A.EMPid Is Null)) 

what i used in Incorta:

or(
    and(
        A.Comp_Id  <> -1, 
        not(isnull(A.EMPid))
    ), 
    isnull(A.EMPid)
)

Thanks

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Your formula seems to be fine.

    In Incorta columns Comp_id and EMPid are coming from the same table? If not, please check the query plan and joins.

    Like
  • Yes, they are coming from the same table.

    Like
    • IncortaUser create a listing table in Incorta dashboard and add following columns to review values in the listing table to debug formula:

      • Comp_id
      • EMPid 
      • or( and( A.Comp_Id  <> -1,  not(isnull(A.EMPid))), isnull(A.EMPid))

      Please share the screenshot.

      Like
Like Follow
  • 3 mths agoLast active
  • 3Replies
  • 41Views
  • 2 Following

Product Announcement

Incorta 5 is now Generally Available