Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I need to calculate the sum, when Recog_Date is >Today AND <= QuarterEnd.
The line below is working
Sum( {<Recog_Date= { ">$(=Date(Today(),'DD/MM/YYYY')) <=30/06/2011"}>} RevenueProductYTD)
but when changing as follows I get a wrong result:
Sum( {<Recog_Date= {">$(=Date(Today(),'DD/MM/YYYY')) <= $(=Date(QuarterEnd(Today()),'DD/MM/YYYY'))"}>} RevenueProductYTD)
What's missing?
Thanks in advance,
Aldo.
Hi,
I solved it as below:
{<
Recog_Date={">$(=Date(Today(),'DD/MM/YYYY')) <=$(=Date(QuarterEnd(Today())+1,'DD/MM/YYYY'))"}>} RevenueProductYTD)
Thanks,
Aldo.
Normal 0 21 false false false DE X-NONE X-NONE MicrosoftInternetExplorer4
Hi,
in your example with the coded date you are 3 months ahead:
30/06/2011.
If you try your set-expression and you tried it on the posting date,
it won't get a result:
quarterEnd of 31/03/2011 is 31/03/2011. So you try:
>31/03/2011 and <= 31/03/2011..
HTH
Hi,
I solved it as below:
{<
Recog_Date={">$(=Date(Today(),'DD/MM/YYYY')) <=$(=Date(QuarterEnd(Today())+1,'DD/MM/YYYY'))"}>} RevenueProductYTD)
Thanks,
Aldo.