4 Replies Latest reply: Nov 21, 2017 3:40 AM by Onno van Knotsenburg RSS

    Comparing Budget vs Actual result

    Maria Ögren

      I would like your help with this, I am trying to create a dashboard comparing budget with sales for specific users.

       

      I do not know how to create the data model to do this correctly without creating cirkular references. Below is a picture of that part of the data model, what I would like to do is to associate the date fields in Budget and Sale.

       

      Since I need to associate the tables on aassociate_id, I can't associate the date fields, because that causes a cirkular reference.

       

      Does anyone know how to solve this?

       

      Datamodel.JPG