Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a scenario where i want to show the text label based on the below scenario. Please suggest.
Year | Quarter |
2024 | Q1 |
2024 | Q2 |
2024 | Q3 |
2024 | Q4 |
2025 | Q1 |
2025 | Q2 |
2025 | Q3 |
here we have 4-Quarters data for 2024 and 3-Quarters for 2025.
1. If the user selects Year as 2024, i should see the text label as 2024-Q4 as the max in Year 2024 is Q4.
2. Approved data for 2025 we have till Quarter 2 only. i should see text label as 2025-Q2.
Thanks in advance.
We can use the MaxString() function here.
When a user selects a year—like 2025
it will return the highest quarter for that year.
For example, if all quarters (Q1 to Q4) are available for 2025, it will show 2025 Q4 using this expression: =[_Fiscal Year] & ' ' & MaxString([Fiscal Quarter])
If I select Fiscal Year 2026 it will return Q2
Let me know if it's working in you case or not.
You could pre-format a dual field for year quarter in the script.
Then you could just use =maxstring(Year_Quarter) to fetch and present the lates year quarter value in your selection.