4 Replies Latest reply: Feb 9, 2017 9:59 PM by Iwona Suliga RSS

    Obtaining single table value for Chart Formula?

    Richard Ouellette

      Hi

      I have a table called Staff24 consisting of 168 values associated with 7 X 24 days/hours that I would like to apply to a daily 24 hour activity chart.  Since a single value is required from the Staff24 table for each hour of the day I am having problems with the formula below.  Attached is a mock up of my effort.  Can you take a look and advise?  Thanks

      Rick

       

       

      Staffed=if(ChtHr=Sch24Hr and Sch24Day=WeekDay(Date_Ver), Sch24Staff, 100) * 7.8  // Sch24Staff filed not being recognized

       

       

      Best

      Rick

       

      Message was edited by: Richard Ouellette to add ExampleSchedule2.qvw 2/11/2017.