And condition between two Input boxes

[#1]

I am trying to create a report in which I am using two input box. Created two variables for them which are being used by two expressions.

When I use one input box the result for the relevant express is correct. But we I use both othem to gether result is not correct.

What I mean to say is for example:

Input box 1  >= 5

Input box 2 >=15

Now result will come in this form

Expression 1	Expression 2
8	0
5	0
0	18
0	134

When I just use one expression then it gives me the right answer, the  values which are infact >= that value. In case of both input boxes used to gether condtion is fullfiled then other shows 0 and vice versa.

Am I missing somehting here?

Can someone help me on this on urgent basis?

Thanks,

TA

[#2]

Hi All,

Here is my senario:

I have three tables (which I have attached as spreedsheet with this questions)

Pageview Last Week

Pagewiewed last 4 weeks and

Users

I want to create a list of user and to show the count of page viewed against name and id

which fulfill the following conditions

Pageview count in last week >= 5 and

Pageview count in last 4 weeks >=16 for example

The way I am trying to handle it as created two variable and input boxes and then used these two variables in expression

Variable 1 for sum page count in last week and

Variable 1 for sum page count in last 4 weeks

and the expressions are

SUM ({<PAGEVIEW_COUNT_Lastweek={">$(Variable1)"}>}PAGEVIEW_COUNT_Lastweek)

and

SUM ({<PAGEVIEW_COUNT_last4weeks={">$(Variable2)"}>}PAGEVIEW_COUNT_last4weeks)

When I use only variable and expression I get the right result but when I use both I dont.

Again I need user list along with actual page counts in last week and last 4 weeks who fulfill  both conditions

Plese help, I would be greatful.

Thanks,

Excel sheets are attahced.

[whiteline]

Hi,  tahirghalib.

You've said that some expression didn't work why don't you post it?

=SUM ({<PAGEVIEW_COUNT_Lastweek={">$(Variable1)"}, PAGEVIEW_COUNT_last4weeks={">$(Variable2)"}>}PAGEVIEW_COUNT_Lastweek)

=SUM ({<PAGEVIEW_COUNT_Lastweek={">$(Variable1)"}, PAGEVIEW_COUNT_last4weeks={">$(Variable2)"}>}PAGEVIEW_COUNT_Last4week)

[#4]

Hi "Whiteline",

I have figured it out and my weekend was saved. It was mistake by my side.

Thanks for being so helpful though.

Thanks Martina you too 🙂

TA