Exprssion Help

[apthansh]

=count({<[Year of Expense] =  {"$(vCurrentYear)"},

               [Month of Expense]={'Jan'},

               Keyplatopco = {"=sum([Expense Amount (USD)]*12) < 75000"},

               [Project Activity Status] ={'Self-Perform','Active'}  >}  ID )

This logic was working until I added Month of Expense = Jan.

Keplatopco is calculated as below,

AutoNumber(RecordId&Year([Payment Date])) as Keyplatopco

do I need to add Month as well to Keyplatopco ?

AutoNumber(RecordId&Year([Payment Date])&Month([Payment Date])) as Keyplatopco

Any help is appreciated.

Thank you.

[vishsaggi]

Can you try this?

=count({<[Year of Expense] =  {'$(vCurrentYear)'},

              [Month of Expense]={'Jan'},

              Keyplatopco = {"=$(= sum([Expense Amount (USD)]*12) < 75000)"},

              [Project Activity Status] ={'Self-Perform','Active'}  >}  ID )

[sunny_talwar]

Is this condition checked at the Month level?

=sum([Expense Amount (USD)]*12) < 75000

[sunny_talwar]

I don't think dollar sign expansion is needed here... this is a search string which has to be between double quotes

[apthansh]

ya...checking this condition at current year and then the Month level as for Month of Jan.

[sunny_talwar · Accepted solution]

Then adding month might make sense or try this

=count({<[Year of Expense] =  {"$(vCurrentYear)"},

               [Month of Expense]={'Jan'},

               Keyplatopco = {"=sum({<[Month of Expense]={'Jan'}>}[Expense Amount (USD)]*12) < 75000"},

               [Project Activity Status] ={'Self-Perform','Active'}  >}  ID )

[sasiparupudi1]

what is the format of the value in [Month of Expense]

?

[apthansh]

Thank you as always