I’m very confused… Hope somebody can give me some light…
Basically, I’m just trying to create a variable, such as
Var1 = count() where <Total_Amount> >2000.
I couldn’t create such variable. So instead, I created three different data providers.
Data Provider1
Date (five days)
Account ID (100*5 days)
Total Amount (given per date and per account id)
where
Total Amount >200
Data Provider 2
Date (five days)
AccountID (70*5 days)
Total Amount (given per date and per account id)
where
Total Amount <=200
Data Provider 3
Date (five days)
Account ID (30*5 days)
Total Amount (given per date and per account_id)
where
Total Amount is null.
Variables Created:
DP1.
Total# of Accounts =count(Account ID)
Average Amount =Total Amount/<Total # of Accounts>
DP2
Total# of Accounts =count(Account ID)
Average Amount =Total Amount/<Total # of Accounts>
DP3
Total# of Accounts =count(Account ID)
Average Amount =Total Amount/<Total # of Accounts>
As you have noticed, I’m duplicating a lot of variables and data providers, just because the condition are different.
It’ll be nice if I could just create variables, such as
Count1 = count(Account ID) where Amount >2000.
But, I can’t put a measure objects in the where clausse.
Is there any way of doing this?
I’ll have to create more data providers to count total, ratio, etc.
There must be a way of doing this.
Could someone help me?
Thumper
thumper (BOB member since 2003-03-21)