2 Replies Latest reply: Jun 27, 2015 1:06 PM by surfman joe RSS

    [sense] how to get another table field's value to calculate what if?

    surfman joe

      I have 2 tables,

       

      table1 is event and store count

      table 2 item, $ sales per store, forecast

       

      My request is, when end user picks an event, the corresponding store count could be passed to table 2 for forecast calculation,

      the function is forecast= $ sales per store * store count.

       

      How to do it? qvf and raw excel files attached. thanks.