Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
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 )
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 )
Is this condition checked at the Month level?
=sum([Expense Amount (USD)]*12) < 75000
I don't think dollar sign expansion is needed here... this is a search string which has to be between double quotes
ya...checking this condition at current year and then the Month level as for Month of Jan.
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 )
what is the format of the value in [Month of Expense]
?
Thank you as always