Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to show only values in FieldA with the most recent Load Date. I can use an expression like =if(LoadDate=vMaxLoadDate,FieldA) but that's no good because when you make a selection, LoadDate pops up in your current selections box.
I was using field triggers and a hidden field to try to solve this, but the client noticed that the back button doesn't work properly when I created that. (You had to hit the back button multiple times to go back.)
Any ideas? Thanks.
Hi.
This should do the trick:
=aggr(if(LoadDate=vMaxLoadDate,FieldA), FieldA)
Hi.
This should do the trick:
=aggr(if(LoadDate=vMaxLoadDate,FieldA), FieldA)