How to get range

[kunkumnaveen]

Hello All,

              Kindly suggest me what i am missing from the below expression,i am getting output as zero

sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"},BVALIDTO={">$(=YearStart(Today(),0,4))"}>}BPrice)

when i tried in two different expressions  it is working

Expression1:   sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"}>}BPrice)

Expression2:   sum({<BVALIDTO={">(=YearStart(Today(),0,4))"}>}BPrice)

when i merge both the expression i am getting zero as output.

Thanks

[prma7799]

Try like this

sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"}>}BPrice)

+

sum({<BVALIDTO={">(=YearStart(Today(),0,4))"}>}BPrice)

[tresB]

Could you share your sample app?

[#4]

Kindly share the dummy data, so that can get back to you with correct set analysis.

[pradosh_thakur]

try

sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"}>} * {<BVALIDTO={">$(=YearStart(Today(),0,4))"}>}BPrice)

regards

Pradosh

[Frank_Hartmann]

Can you share a sample?