Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
Very good Day!
I am trying to get the condition Dimension on the straight table using the below condition
=IF([FM Name]<>[EM Name],if([Contract Type]='Non perm (T&M)',[Employee Name],if([Contract Type]='Perm',[Resource GCB Grade]>='6',[Employee Name])))
I need to display the employee names only it meets the above criteria but I am not getting desired correct result.
=if([FM Name]<>[EM Name] and [Contract Type]='Non perm (T&M)',[Employee Name],if([FM Name]<>[EM Name] and [Contract Type]='Perm',[Resource GCB Grade]>='6',[Employee Name]))
try this
Share some sample data and the output you are getting for proper analysis
but from a high level there seems to be some syntax issues. see below in red (replaced , with and)
=IF([FM Name]<>[EM Name],if([Contract Type]='Non perm (T&M)' , [Employee Name],if([Contract Type]='Perm' and [Resource GCB Grade]>='6',[Employee Name])))
=if([FM Name]<>[EM Name] and [Contract Type]='Non perm (T&M)',[Employee Name],if([FM Name]<>[EM Name] and [Contract Type]='Perm',[Resource GCB Grade]>='6',[Employee Name]))
try this