Set analysis

[nareshthavidishetty]

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..

[sunny_talwar]

May be try this:

=Sum({$<AuditDate = {">='9/1/2016'<='9/3/2016'}>} PostedSales)

[nareshthavidishetty]

Hi Sunny,

It's showing no results..

Thanks..

[sunny_talwar]

How is AuditDate formatted?

[trdandamudi]

May be try  this:

=Sum({$<AuditDate = {">=9/1/2016<=9/3/2016"}>} Sales)

[sunny_talwar]

Yes, I should have not added the single quotes

[trdandamudi]

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)

[sunny_talwar · Accepted solution]

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

[sunny_talwar]

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.

[trdandamudi]

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)