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?

      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.