Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to use aggr in the set analysis for sum.. existing is my syntax
sum({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum)/count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])
I need to put aggr as below but this is giving an incorrect syntax.. Need to group the sum by TR
sum(aggr({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum), TR)/count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])
May be this:
Sum({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>} Aggr(Only({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum), TR))/Count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])
try (Change sum(aggr)
aggr(sum({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum), TR)/count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])
May be this:
Sum({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>} Aggr(Only({<[Referred to CPS] ={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}Aging_Sum), TR))/Count({<[Referred to CPS]={'Y'},Application={'HSBCNET'},[Service Lines]=,Month=,Weekstart=>}[Aging Buckets])
Thanks Sunny.. Why has the Set analysis used twice i.e. before Aggr and again with Aggr ?