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

    Help with formulae

    Gavin Rainey

      Hi,

       

      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.