Expressions

[savithri_n_s]

Hi Sunny,

Thanks for helping me

Can you please tell me what is wrong in the below expressions and also how to add average column in straight table in sheet5 as

shown below (3.)

1. count({<[Data Source] = {'CX Managed','Cx Managed'}, [Assignment State]= {'Effective','Effective-OnBoard'},DISTINCT([Client - Normalized])>}[Client - Normalized]

2. (sum({<[Data Source] = {'CX Managed','Cx Managed'}, [Assignment State]= {'Effective','Effective-OnBoard'},sourcingmethod={'Requisitioned'}>}
If([Assignment Start date] >=MonthStart(Date#(Left(SubField([Current Month/Year], ',', 1), 3) & ',' & SubField([Current Month/Year], ',', 2), 'MMM, YYYY')) and [Assignment Start date] <= MonthEnd(Date#(Left(SubField([Current Month/Year], ',', 1), 3) & ',' & SubField([Current Month/Year], ',', 2), 'MMM, YYYY')), [Data Source]))/
Count({<[Data Source] = {'CX Managed','Cx Managed'}, [Assignment State]= {'Effective','Effective-OnBoard'},sourcingmethod={'Requisitioned'}>}
If([Assignment Start date] >=MonthStart(Date#(Left(SubField([Current Month/Year], ',', 1), 3) & ',' & SubField([Current Month/Year], ',', 2), 'MMM, YYYY')) and [Assignment Start date] <= MonthEnd(Date#(Left(SubField([Current Month/Year], ',', 1), 3) & ',' & SubField([Current Month/Year], ',', 2), 'MMM, YYYY')), [Data Source])))

3.

US_GU_RES_OG - Metric Name	Sep-17	Oct-17	Nov-17	Dec-17	FY18 Average
# of Active NA Cx Managed Contractors	456	475	468	436	466
# of Active Direct Sourcing Contractors **	29	26	25	25	27
# of Active NA Cx Enabled Contractors	64	62	58	57	61

[shilpan]

Issue seems to be with your data model. Can you use current month instead of current month/year?

[savithri_n_s]

Hi patel

Thanks I will check.it would be great if you can tell me you to add fy18 average column as shown above?