lightsection
Contributor III
2020-05-30
09:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
677 Views
1 Solution
Accepted Solutions
vamsee
Specialist
2020-05-30
06:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Sum({<[Actual Date]={"$(=Max([Actual Date]))"}>}Cummulative Revenue Budget CAD)
2 Replies
vamsee
Specialist
2020-05-30
06:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Sum({<[Actual Date]={"$(=Max([Actual Date]))"}>}Cummulative Revenue Budget CAD)
lightsection
Contributor III
2020-06-08
11:38 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks. that works !
614 Views