Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
lightsection
Contributor III

Set Analysis to fetch associated field value based on Max Date

 

I would like to fetch the last value of "Cummulative Revenue Budget CAD" based on selected date period flag (Selections shown on the left side of the screenshot) 

lightsection_0-1590844848028.png

 

Labels (3)
1 Solution

Accepted Solutions
vamsee
Specialist

Try

Sum({<[Actual Date]={"$(=Max([Actual Date]))"}>}Cummulative Revenue Budget CAD)

 

View solution in original post

2 Replies
vamsee
Specialist

Try

Sum({<[Actual Date]={"$(=Max([Actual Date]))"}>}Cummulative Revenue Budget CAD)

 

lightsection
Contributor III
Author

Thanks. that works !