Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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') & '%',
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')& '%',
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') & '%',
Hi Sunny ,
Thank You so Much, it works.
Best Regards,
HK
Hi Raman,
Thank You for your Reply. it also works fine.
Best Regards,
HK