3 Replies Latest reply: Oct 22, 2016 7:10 AM by Ganesh Bagavathi RSS

    Cross Join

    Ganesh Bagavathi

      Hello,

       

      I am trying to calculate a new value by multiplying two fields from 2 different tabs of the excel input. The sample QVW file and the Excel input are attached here. Please give me your suggestions.

       

      Please let me know if more information is needed.

       

      Expected Output:

      Forecast.JPG

      Actual Value is from the Sheet:Forecast Final

      Percentage from Sheet:Allocation Percentage Final

       

      Thanks.