0

Full outer join without MW

I have 2 tables: Product and Sell, so I want to get the result like below without use MW, how can I do it, thanks !

 

7replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Nopu,

    This video shows how to design this in Incorta:

    - https://youtu.be/rzGtkUmC0zc

    Like 1
      • Nopu Nguyen
      • Human
      • Nopu_Nguyen
      • 3 wk ago
      • Reported - view

      Anurag Malik Thank you so much !

      Like
      • Nopu Nguyen
      • Human
      • Nopu_Nguyen
      • 3 wk ago
      • Reported - view

      Anurag Malik I tried to add a fomular column named is Status what is `G` if quantity > 0 and 'N' if quantity = 0 or null but It not show value at empty group, could you teach me ?

      Like
    • Anurag Malik - was that 4.9? It looks great!

      Like
    • Marc Paige yes this in 4.9.

      Like
    • Anurag Malik - I am looking forward to the new UX!

      Like
    • Nopu Nguyen please use this formula similar to this under Measure:

      if(
          sum( sales2_S.sales.quantity  ) > 0, "G",  "N"
      )

       

      It will show status like this:

      Like 1
Like Follow
  • Status Answered
  • 3 wk agoLast active
  • 7Replies
  • 23Views
  • 3 Following

Product Announcement


We are happy to
announce Incorta 4.8 !!!