5 Replies Latest reply: Oct 6, 2017 12:15 PM by Frank Hartmann

# How to get range

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

• ###### Re: How to get range

Try like this

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

+

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

• ###### Re: How to get range

Could you share your sample app?

• ###### Re: How to get range

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

• ###### Re: How to get range

try

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

regards