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

    How to get range

    naveen kumar

      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.




      Capture.PNG

      Thanks