Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have selected a date from a multibox and would like to use set analysis with the whole set (1) in order to sum a field that is
SUM({1<datefield={Highest value less than date selection}>}Sumfield)
Is that possible?
Missed a parenthesis
Sum({1<datefield = {"$(=Date(Max({<datefield = {[$(='<' & Date(Min(datefield)))]}>} datefield)))"}>} Sumfield)
May be this?
= SUM({<datefield= { [$(=GetFieldSelections(YourfieldselectionFieldname))] } >}Sumfield)
Almost there
It also needs to be latest date less than the selection.
May be using nested set analysis
Sum({1<datefield = {"$(=Date(Max({<datefield = {[$(='<' & Date(Min(datefield))]}>}datefield)))"}>} Sumfield)
Missed a parenthesis
Sum({1<datefield = {"$(=Date(Max({<datefield = {[$(='<' & Date(Min(datefield)))]}>} datefield)))"}>} Sumfield)
My bad completely misunderstood the question. Try sunny's expression and let us know. 🙂
A search string within a set expression will do:
Sum( {<Date={'$(=Max({<Date={"<$(=Date)"}>} Date))'}>} Sales)
Replace Date with datefield and Sales with Sumfield above ...
Thank you!