Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two date fields, one is Trade_Date and seconde one is Maturity Date.
Now i want to have two from and to date options, (pls see attachment)
User will able to select both ranges in Trade date and maturity date, and click on a button.
All the trades happend in that date range and out of that how many matured in the range of maturity date should be displayed.
Please let me know if you need more clarity on this.
Thanks
Ren
1) Create 4 variables and attach calendars to each one
2) Use Set Analysis to filter your data according to variables
Example
SUM({< Trade_Date={">=$(var1)"}*{">=$(var2)"}, [Maturity Date]={">=$(var3)"}*{">=$(var4)"}>}Value)
Hi,
I have made it through Button Click event as well as through SET analysis. See the attachment.
FYI - I just used Trades From and To date.