10 Replies Latest reply: Feb 8, 2017 7:05 AM by Stefan Koppejan RSS

    Divide measure before date X

    Stefan Koppejan

      Hello all,

       

      I really need some help, I have the following chart:

       

      Capture.PNG

      formulas are:

      Aantal klantvragen: count({<[Klant label]={'XX'},[Month]=>}AppID)

      Verzekerd: count({<[Klant label]={'XX'},[IsVerzekerde]={1},[Month]=>}AppID)

       

      What I want and can't get working. I would like to divide al numbers before Date 25-11-2016 by 2. And round up.

       

      numbers would be like:

       

      Aantal klantvragen:

      jan 238

      feb 192

      mrt 314

      dec 230

       

      I have a Date field in format 'DD-MM-YYYY'.

       

      I hope someone can help me.

       

      Thanks!

       

      Regards Stefan