03-01-2017 7:50 AM - edited 02-03-2024 8:13 PM
Hi.
I made a CDS view which contains monthly revenue.
What I want to do is to aggregate this year's revenue.
My CDS view contains FiscalYear field but I have no idea to get this year's data.
I've tried to use predefined functions in where clause to restrict FiscalYear field but it didn't be allowed.
For example,
where FiscalYear = left(TSTMP_CURRENT_UTCTIMESTAMP(), 4)
-> Random expressions are not supported in a condition.
Is it impossible to use predefined functions in CDS where clause?
I'm new to CDS, please suggest me a solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.