Need to add values before a particular date

[#1]

I would like to add values before a particular date and I am using following formula. Though the expression is OK, but I am still not able to get desired result.

if([Posting Date]<='2013/03/31',Sum(Quantity))

Please help me.

Regards

Sangeet Malhotra

[#2]

Hi Reshma,

This is not working. I would like to make expression in such a way that it picks data on the basis of Store and brand for a particular month, which I can compare with my Sales Data. I can have a word with you also to explain the same. Please allow.

Regards

Sangeet Malhotra

[jagan]

Try this expression

=Sum({<[Posting Date]={"<=$(Date(Date#('2013/03/31', 'YYYY/MM/DD'), 'DD/MM/YYYY hh:mm:ss TT'))}>}Quantity))

Regards,

Jagan.

[#4]

Hi Jagan,

I am not using variables but static values. How to handle it?

Regards

Sangeet

[jagan]

Hi,

On what basis you have choosen the date 3/31/2013?  Based on this we can arrive a dynamic one.

Regards,

Jagan.

[#6]

Hi Jagan,

I have got data in SQL, which i have extracted using View into a separate table. I would like to make expression in such a way that it picks data on the basis of Store and brand for a particular month, which I can compare with my Sales Data. The data is regarding Stock and I need stock for a particular store and for a particular month. I have got following fields

Location Code

Brand Code

Posting Date

Quantity.

I need to add quantity to extract stock details of each month.

Regards

Sangeet Malhotra

[sasiparupudi1]

Please post your qvw or sample data

[#8]

Dear Sasidhar,

Here is my QVW.

Regards

Sangeet

[#9]

Dear Sasidhar,

I can share my data also if required. Please suggest.

Regards

Sangeet

[sasiparupudi1]

Please use the following expression

Sum({<[Posting Date]={'<31/03/2013 12:00:00 AM'}>}Quantity)

[#11]

Dear Sasidhar,

This is also not resolving the issue. My stock on 31/03/2013 was 24 and its showing -15. Kindly help.

Regards

Sangeet