3 Replies Latest reply on Jan 28, 2017 9:09 AM by philmodjunk

    Graph of sales per supplier

    AndrewJudd

      hi all, I'm trying to build a chart to display totals sold per artist in the current year.

       

      I have a tables as below -

       

      ARTWORKS (inventory) = INVOICE LINE ITEMS = INVOICES

       

      as normal

       

      then I have (as attached)

       

      HOME (where charts are displayed in a slide control) = INVOICES LINE ITEMS | CHART (based on primary key and an unstored calculation of the invoice date from invoices to a gdate field that auto enters the year from get current year (as attached). The graph appears empty unless the c_Invoice_Year is turned into a text or number field and the numbers are added.

       

      Can charts not work off unstored calculations?

       

      Do this mean scripting an invoice date directly into the line items field every time an item is added and also if the invoice date is changed?

       

      Thanks!

       

       

      Screen Shot 2017-01-28 at 13.04.44.png