beck_bakytbek
Master
2023-02-10
09:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
max value of a specific type
Hi Folks,
my Table does look like
MonthNum | Version | Sum(Sales) |
1 | Actual | 5 |
2 | Actual | 10 |
3 | Budget | 15 |
4 | Budget | 20 |
my expected output is : i only want to show: the second value of Version: Actual and Sum: 10
i am using this expression: Sum ({<Version = {"Actual"}, MonthNum={"$(=Max(MonthNum))"}>}Sales) and want to ignore the selection (Frontend) in Field: Version. But this expression doesnt work.
Does anybody have any idea how to resolve this issue?
Thanks a lot in advance
725 Views
2 Replies
ogster1974
Partner - Master II
2023-02-10
12:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum ({<Version = {'Actual'}, MonthNum={"$(=Max(MonthNum))"}>}Sales)
beck_bakytbek
Master
2023-02-12
07:32 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@ogster1974 Thanks a lot for your responce, i will implement it and will let know when i achieve the expected output. Thanks a lot for your help and time