SELECT has invalid inputs

[BHUVANESH]

BELOW SENTENCE IS THE EXPRESSION

Select(work Package Security[Security],[_THISROW].[work package].[wardcode].[ward]=[wardcode],MAX(work Package Security[Assessment Timestamp]))

IS SHOWS ---- SELECT has invalid inputs..

whats wron on this Expression..please any one Clarify

[1minManager]

So this bit:

Select(work Package Security[Security],
[_THISROW].[work package].[wardcode].[ward]=[wardcode],
MAX(work Package Security[Assessment Timestamp])
)

Is not syntax correct.  What are you trying to do here?

Also if you're doing a Select() with two or more constraints then you need to do:

Select(TableName[ColumnName],AND(

[A]=1,

[B]=2,

)

)

Simon@1minManager.com