Calculation of object based on user response

[former_member279151]

Hi All,

I would like to calculate the value for attribute Beginning balance based on user response as shown below. Here user would be selecting the month number and Year in the filter as prompt and based on month number and year selection he should see the data as shown in Results (Date Range).

Please let know how this can be achieved. Appreciate your response

Thanks,

Eswar

Scenario #	If user runs report on	Prompt	Month	Year	Results(Date Range)	Previous day
1	July 15	July	July	2015	1st thru 14th	June 30th
2	Aug 1st	July	July	2015	All July activity 1st – 31st	June 30th
3	Aug 15th	July	July	2015	All July activity 1st – 31st	June
4	Aug 15th	August	August	2015	Aug 1 – 14th	July 31st
5	Oct 15th	September 2014	September	2014	All of September 2014	Aug 31st

[Former Member]

What data source are you reporting against? Solution and syntax will vary depending on that.