0 Replies Latest reply: Jul 27, 2016 11:11 AM by juan prado RSS

    Help with dates!

    juan prado

      Hi!

       

      I have the following problem:

       

      I have a table for Clients_ID, each Clients_ID have different amount of certificates listed, for ex.

       

      Client_ID 1 have 5 Certificates so i can create CLIENT_ID as a KEY and CLIEND_ID_CERTIFICATE like 1-1, 1-2, 1-3, 1-4 and 1-5

       

      For each CLIENT_ID I have a Suscribe_Date and for each Certificate I Have other Suscribe_Certificate_Date.

       

      Also i have Billing and Collections table with Billing_Date and Collection_Date.

       

      I have Client_ID for Billing and Collections tables and Billing_ID for each tables too. So I can make a relationship between all the tables with Client_ID   as Key Field. And make a relationship between Billing and Collections with CLIENT_ID_BILL_ID as a Key Field only for those tables.

       

      I create a MasterCalendar for each table (Clients, Certificate, Billing and Collections) and a CommonCalendar with the intention of make a MonthYear to create a line chart for view the evolution of Billing and Collections but when i Use the Common MonthYear values are multiplied.

       

      THANKS YOU!

      error.PNG

      mindaugasbacius rwunderlich