Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Thabang231
Contributor III
Contributor III

Creating variables

Good day 

I would like assistance here, I want to create a variable to only pick this current FY the field contain F2022, F2023, F2024, 

i want a variable to only pick the F2024 which is current.

Thanks

 

Labels (1)
1 Solution

Accepted Solutions
marksouzacosta
Partner - Specialist II
Partner - Specialist II

You can create a variable with the definition below. Note it will ignore any selection you made in your User Interface:

marksouzacosta_2-1719346901359.png

 

=MaxString({1} FiscalPeriod)

 

Read more at Data Voyagers - datavoyagers.net

View solution in original post

1 Reply
marksouzacosta
Partner - Specialist II
Partner - Specialist II

You can create a variable with the definition below. Note it will ignore any selection you made in your User Interface:

marksouzacosta_2-1719346901359.png

 

=MaxString({1} FiscalPeriod)

 

Read more at Data Voyagers - datavoyagers.net