Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have some Customers (Field Customer) and every customer can have some kind of card or even a few cards. For every card, there is a date of last change, e.g. a card can have several dates. I want to sum up how many money (Field money) is left on every card of every customer, but just using the latest date of change. This means if I have dates 2018-05-01 and 2018-06-23, I only want to use the value of the money field, which corresponds to the latest date.
I try to do this in a text box, but I think I am failing.
A Set Analysis expression using the max(DateChange) is not the right thing.
Any suggestions? Is this even possible in a text box?
Thanks!
May be this
FirstSortedValue(Aggr(Sum(Value), DateChange, Customer), -Aggr(DateChange, DateChange, Customer))