Divide measure before date X

[skoppe]

Hello all,

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

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

[skoppe]

Yes I tried, thanks. Sunny pointed me to aggr() function, this works.

regards Stefan