2 Replies Latest reply: Feb 19, 2018 12:38 AM by Vikraant Koushika Pai RSS

    mathematical calculation in Qlik script

    virendra chawra

      Hi,

       

      We have one of the requirements where our data looks like below:

       

           

      IDBooking ActualTotal SeatsBudget ActualTotal  budget rooms
      11200511504
      27803840

      3

       

       

      and we want to calculate formula in a script itself.

       

      % Revenue= (sum(BookingActual)/sum(Total Seats) - sum(BudgetActual)/sum(Totalbudgetrooms)) / sum(BudgetActual)/sum(Totalbudgetrooms)

       

       

      please suggest the same.