Set analysis problem

[#1]

Hi,

I must calculate stock on two given dates. Set analysis are

Sum({1<Date={"<=$(vFirstDate)"}>}Quantity)

Sum({1<Date={"<=$(vSecondDate)"}>}Quantity)

Both results are always same despite different dates.

Any ideas?

TIA

[#2]

I have table with posting dates and quantity. If I wish get stock on the certain date I must sum all quantity transactions from first date. My result table must show stock on two different selected dates .

[Kushal_Chawda]

try to exclude other period filters

Sum({1<Date={"<=$(vFirstDate)"}, Year, Month, Quarter>}Quantity)

Sum({1<Date={"<=$(vSecondDate)"},Year, Month, Quarter>}Quantity)

[#4]

Actually I don't have any other period filter..

[sunny_talwar · Accepted solution]

How about this?

Sum({1<Date={"<=$(=vFirstDate)"}>}Quantity)

Sum({1<Date={"<=$(=vSecondDate)"}>}Quantity)

or

Sum({1<Date={"<=$(=$(vFirstDate))"}>}Quantity)

Sum({1<Date={"<=$(=$(vSecondDate))"}>}Quantity)

[Kushal_Chawda]

I think you already have identifier as 1, I didn't noticed. But how you are getting the values in both the variables?

[#7]

From Slide/Calendar object

[#8]

Thx a lot, first solution works for me

I owe you a beer

[sunny_talwar]

What's the address?