Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try this expression
=Sum({<[Posting Date]={"<=$(Date(Date#('2013/03/31', 'YYYY/MM/DD'), 'DD/MM/YYYY hh:mm:ss TT'))}>}Quantity))
Regards,
Jagan.
Hi Jagan,
I am not using variables but static values. How to handle it?
Regards
Sangeet
Hi,
On what basis you have choosen the date 3/31/2013? Based on this we can arrive a dynamic one.
Regards,
Jagan.
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
Please post your qvw or sample data
Dear Sasidhar,
Here is my QVW.
Regards
Sangeet
Dear Sasidhar,
I can share my data also if required. Please suggest.
Regards
Sangeet
Please use the following expression
Sum({<[Posting Date]={'<31/03/2013 12:00:00 AM'}>}Quantity)
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