help with expression

[#1]

Hi All,

I have the following expression and i need to add something to it but struggling to get it working.

the current expression is

count({$<[Source]= {"EX"}>}distinct [Allocation Legacy Key])

I want to add a condition so that it only counts the lines where :

[Sent for Payment Date]-[Transaction Date]>60

Can anyone help me with adding this into the expression?

Many thanks

[Gysbert_Wassenaar · Accepted solution]

Something like this maybe:

count({$<[Source]= {"EX"},[Allocation Legacy Key] ={"=[Sent for Payment Date]-[Transaction Date]>60"} >}distinct [Allocation Legacy Key])

[#3]

Nice one Gysbert! works a treat!

Thanks