Use selection as parameter in expression

[patrickbender]

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?

[vishsaggi]

May be this?

= SUM({<datefield= { [$(=GetFieldSelections(YourfieldselectionFieldname))] } >}Sumfield)

[patrickbender]

Almost there

It also needs to be latest date less than the selection.

[sunny_talwar]

May be using nested set analysis

Sum({1<datefield = {"$(=Date(Max({<datefield = {[$(='<' & Date(Min(datefield))]}>}datefield)))"}>} Sumfield)

[sunny_talwar · Accepted solution]

Missed a parenthesis

Sum({1<datefield = {"$(=Date(Max({<datefield = {[$(='<' & Date(Min(datefield)))]}>} datefield)))"}>} Sumfield)

[vishsaggi]

My bad completely misunderstood the question. Try sunny's expression and let us know. 🙂

[petter]

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 ...

[patrickbender]

Thank you!