Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like this
sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"}>}BPrice)
+
sum({<BVALIDTO={">(=YearStart(Today(),0,4))"}>}BPrice)
Could you share your sample app?
Kindly share the dummy data, so that can get back to you with correct set analysis.
try
sum({<BVALIDFROM={"<$(=YearStart(Today(),0,4))"}>} * {<BVALIDTO={">$(=YearStart(Today(),0,4))"}>}BPrice)
regards
Pradosh
Can you share a sample?