3 Replies Latest reply: May 17, 2018 6:41 AM by youssef belloum RSS

    Ratio calculation from two table

    Prashant Sancheti

      Hi Team,

       

      I have 2 table

       

       

      Table 1 :   :Date,Country,Region,State,DailySales,MTDSales,QTDSales



      Table 2: Date,Country,BudgetAmount

       

       

      I want t create a on more fired which will be Margin% = (MTDsales value at selected Business Date) /  (Budget Amount of Monthstart date)

       

      How we can calculate this in Load Script ?

       


      If user select a for ex; 15th May 2018 then Margin % = (MTDsales value at 15th May 2018) / 9Budget Amount at 01st may 2018.)