AnsweredAssumed Answered

SUM Function Script help - Filemaker Pro 12

Question asked by DerekPopovich on Nov 10, 2013
Latest reply on Nov 12, 2013 by DerekPopovich

Title

SUM Function Script help - Filemaker Pro 12

Post

     Hello,

     I have a table with 4 field: ID, code, Date and Value.

     ID -- code --    DATE       -- Value 

      1 -- 0001 -- 2013-01-01  -- 55

      2 -- 0002 -- 2013-01-01 --  45

      3 -- 0003 -- 2013-01-01 --  30

      4 -- 0001 --  2013-02-01 -- 50

      5 -- 0002 -- 2013-02-01  -- 50

      6 -- 0003 -- 2013-02-01  -- 50

      

     I need a script that will add the value based on the code's (manual set) and the date which will give me a result such as:

     I type in the script the code I want to add up (002 and 003) as Total

     The end result should be:

     date             -- total

     2013-01-01 -- 75

     2013-02-01 -- 100

     The script will be use in a chart so I can chart the "total" of few codes combine vs the date.

     Has anyone has any idea on how to do this?

     I try using the SUM function but I don't get the data I need.

     I have search for sample scripts and information but I am very lost,

     I have not been able to find any examples for 2 days and some help will be very much appreciated.

      

     Sincerely, DPP

Outcomes