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: 
Siddhanttomar
Contributor
Contributor

set analysis

How to find the Year till date(YTD) with the help of set analysis?

Labels (5)
3 Replies
Bunim
Contributor III
Contributor III

aggr(only({<Year={"<$(=year(date))"}>}Year),Year)

Iswarya_
Creator
Creator

Hi @Bunim 

YTD:

sum({$<Year=,Month=, DateFieldName={'>=$(=YearStart(Today()))<=$(=Today())'}>}Revenue)