Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We need the data between the date ranges.Below is the logic which is not getting results.Please provide the right expresiion.
=sum({$<AuditDate >={'9/1/2016'}<={'9/3/2016'}>}PostedSales)
Thanks..
I still don't think it would work, for my solution to work, in addition to adding ending double quote, I will need dollar sign expansion:
=Sum({$<AuditDate = {"$(='>=9/1/2016<=9/3/2016')"}>} PostedSales)
but why go through all that hassle, when we can just do what you proposed
May be try this:
=Sum({$<AuditDate = {">='9/1/2016'<='9/3/2016'}>} PostedSales)
Hi Sunny,
It's showing no results..
Thanks..
How is AuditDate formatted?
May be try this:
=Sum({$<AuditDate = {">=9/1/2016<=9/3/2016"}>} Sales)
Yes, I should have not added the single quotes
Sunny,
Is it because the double quote ( " ) is not closed :
=Sum({$<AuditDate = {">='9/1/2016'<='9/3/2016'}>} PostedSales)
May be like below ?
=Sum({$<AuditDate = {">='9/1/2016'<='9/3/2016' "}>} PostedSales)
I still don't think it would work, for my solution to work, in addition to adding ending double quote, I will need dollar sign expansion:
=Sum({$<AuditDate = {"$(='>=9/1/2016<=9/3/2016')"}>} PostedSales)
but why go through all that hassle, when we can just do what you proposed
Or may be it would work without dollar sign expansion also, I am confused and will have to test it out. But I guess I usually don't even use hard-coded values.
You are right, adding double quote not worked... but I also tried dollar sign expansion as below but no luck.. I thought this will work....
=Sum({$<AuditDate = {"$(='>=9/1/2016<=9/3/2016')"}>} PostedSales)