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.)