Aggregated expression

[dunnalahk123]

Hi,

Can some one help me here for below Aggregated Expression which i need to include some more values how can i do that.

Num(Avg(Aggr(Avg([PCINEW]), [PCINEWProjectID])),'#,##0')& '%',

i want to add below values as well.

[Project Status]<>'Completed','Merged','Cancelled'

[PSA Delivery Type]<>'Channel Partner'

[Project Creation Text]='Automatic by PG'

best Regards,

HK

[raman_rastogi]

Try this

Num(Avg(Aggr(Avg({<[Project Creation Text]={'Automatic by PG'},[PSA Delivery Type] -='{Channel Partner'} ,[Project Status]-={'Completed','Merged','Cancelled'}>}[PCINEW]), [PCINEWProjectID])),'#,##0')& '%'

Num(Avg(Aggr(Avg({<[Project Creation Text]={'Automatic by PG'},[PSA Delivery Type] ={'*'} - {'Channel Partner'} ,[Project Status]= {'*'} - {'Completed'}-{'Merged'}-{'Cancelled'}>}[PCINEW]), [PCINEWProjectID])),'#,##0')& '%',

[sunny_talwar · Accepted solution]

May be this

Num(Avg(Aggr(Avg({<[Project Status] -= {'Completed', 'Merged', 'Cancelled'}, [PSA Delivery Type] -= {'Channel Partner'}, [Project Creation Text] = {'Automatic by PG'}>} [PCINEW]), [PCINEWProjectID])),'#,##0') & '%',

[dunnalahk123]

Hi Sunny ,

Thank You so Much, it works.

Best Regards,

HK

[dunnalahk123]

Hi Raman,

Thank You for your Reply. it also works fine.

Best Regards,

HK