I am in 3.1 with this client.
I am trying to get a parameter to work (numbers 1 to 12), which should work as a fiscal year start.
This works perfectly in a crosstab, if I used a hard-coded number, such as 6.
[CY] is a calendar year
[CY Month Number] is a calendar month number.
=If [CY Month Number] >= 6 Then ([CY] + 1) Else [CY]
If I use a separate query (DP) and try to use in the report - either as a measure, with max() function, or detail object (of [CY Month Number]) I always get #MULTIVALUE error.
This is what it SHOULD look like:
The requirement is to make a custom fiscal year start, which should reset both month numbers and the actual year (!). The months are working fine. I can’t get the year to work.
Things I have tried:
=Max([Month Prompt].[CY Month Number]) + [CY]
Where [Month Prompt].[CY Month Number] is a single numeric value from a different query (DP) from a prompt.
Can someone suggest a good way to do it?