Using "and" in a set expression

[kevinstanfield]

Hi, I'm struggling with the following set analysis - I 'm getting a syntax error

=count({$<[Overdue Account] ={'Y'}>* $ <[Debt Date] = {'$(=max([Debt Date]))'>}[Account Number])

The error is as follows - both elements work individually & the error message shows the correct value for the max([Debt Date]) i.e. 4

The error message is shown on the attachment.

As always thanks for looking.

Kevin

[Anil_Babu_Samineni]

Why are you trying cartesian here? How about this? 

=count({$<[Overdue Account] ={'Y'}, [Debt Date] = {"$(=Date(max([Debt Date]), 'Your Format here'))">}[Account Number])

[Vegar]

Have you tried this expression?

=count({$<[Overdue Account] ={'Y'}> } * { $ <[Debt Date] = {'$(=max([Debt Date]))'>}[Account Number])

[sunny_talwar · Accepted solution]

@kevinstanfield Try this

=Count({$<[Overdue Account] = {'Y'}, [Debt Date] = {"$(=Max([Debt Date]))"}>}[Account Number])

[kevinstanfield]

Thanks Sunny

[kevinstanfield]

Thanks Anil, I went with Sunny's solution but will try this and keep for future reference

[kevinstanfield]

Thanks Vegar, I went with Sunny's solution but will take a look at this as well