2 Replies Latest reply: Jun 24, 2016 4:07 AM by bruno bertels RSS

    Help with formulae



      I have some SQL I used before with SSRS and I want to replicate the logic in Qlik and am stuck at this point:


      (NumberOfTickets/Hours worked(for all months in the year to date)/Number of months in the year)*1,000,000


      I would also like the 1,000,000 to be interchangeable from 1 to 2 million.


      Help with best way to do this would be greatly appreciated.