Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends
I want to check a user given date in date list .whether is it there or not, If there means I need to show sum of values automatically.
I did it but it show me when I select date from date list which is same as i was entered in input box. But I need to show the value without selecting date from list box..
This is the variable using in an input box. and my expression is
=if((Date=vDate),Sum(Value)) when i select '08-06-2015' from date list it show me sum of value of the date. But I want to show the sum of value without am selecting value from date list....
And my table is
I am waiting for your response friends.,....
Exp: Sum({<Date={'$(vDate)'}>} Value)
Right click on input box->Properties->Number ->Mixed
Enter the date in DD MMM YYYY format in input box
Hey really awesome. thanks to all to give perfect output.
Hi,
Use calander object and Expression which is mentioned by Manish. That will works fine.