Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
yogitamehta10
Creator
Creator

Text box expression

Hi All,

i need to show Latest Month and cycle field in text box . my month field is like C10 2017, C92017 ,C82017. i can not do max as we i have all the 12  cycle in data all the time.
but i have a column in data that tell  this is latest cycle.)

Month field  column
c10 2017      Latest cycle
c10 2017      Latest cycle
.

.
.
c09 2017        Last cycle

i want to show Last cycle Month field in text box.

TIA!

1 Reply
woshua5550
Creator III
Creator III

Try this ?

Only({<column = {'Last cycle'}>}[Month field])