Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following logic of which I need to amended to add in extra criteria, however, I don't know where to add this is.
I need to to include: Type='TY' within the calculation below, any idea how to do this please?
Aggr(RangeSum(Above(Count(Count_Flag), 0, RowNo())),Exp_Group,(months_start,(Numeric,Ascending)))
/
Aggr(count(TOTAL <Exp_Group> Count_Flag),Exp_Group,(months_start,(Numeric,Ascending)))
You can use set expression.. Count( {<Type={'TY'}>} Count_Flag)
Also look into this article : Set-Analysis-in-the-Aggr-function