system
April 7, 2005, 9:43am
#1
Hi,
I’m facing a problem where I using this formula :
Where (=)
The “Actual Month” is variable I created and it holds this Formula =Max() where is a number
What’s going wrong ???
Does someone faced the same problem ?
Thanks for your responses
Arcondo (BOB member since 2004-11-08)
system
April 7, 2005, 9:47am
#2
You cannot put a where condition on a measure. Try with this
If(<Month>=<Actual Month>) then <Profit>
Let us know if this too doesn’t work.
venira (BOB member since 2004-12-07)
system
April 7, 2005, 11:41am
#3
Thanks a lot for your help. I follow your suggestion and now I have #computation error ???
Arcondo (BOB member since 2004-11-08)
system
April 7, 2005, 11:47am
#4
Your explaination makes me to guess that all the objects are measures.anyway, can you let me know the object type of month,actual month and profit.
venira (BOB member since 2004-12-07)
system
April 7, 2005, 11:56am
#5
All are numbers. (ex: feb 2005 = 200502)
Arcondo (BOB member since 2004-11-08)
system
April 7, 2005, 11:59am
#6
sorry to ask you again…i wanted the object type in BO but not the data type of the field in the data base.
venira (BOB member since 2004-12-07)
system
April 7, 2005, 12:04pm
#7
If all the objects are measures, you cannot acieve it as we cannot putconditios on aggregated measures.
venira (BOB member since 2004-12-07)
system
April 7, 2005, 12:55pm
#8
I understand you. In fact my query retreive me several Months and I need to choose the profit according to a specific month.
Do you have any idea how we can acheive that.
Thanks.
Arcondo (BOB member since 2004-11-08)
system
April 7, 2005, 4:02pm
#9
The answer is in this FAQ entry.
Dwayne Hoffpauir (BOB member since 2002-09-19)
system
April 8, 2005, 9:53am
#10
Thanks Dwayne for your reply.
But still don’t solve my probs. I’m agree with you when in the Flag Object it looks like : (=Constant) where is numeric
In fact, I’m using (=Max()), then the flag is considered as measure. As far as I know there is no way to put it in the clause “Where” without ending with DMB0007
Do you have any other workaround ?
Thanks in advance.
Arcondo (BOB member since 2004-11-08)
system
April 8, 2005, 4:42pm
#11
Arcondo:
But still don’t solve my probs. I’m agree with you when in the Flag Object it looks like : (=Constant) where is numeric
In fact, I’m using (=Max()), then the flag is considered as measure. As far as I know there is no way to put it in the clause “Where” without ending with DMB0007
I’m not sure you’re using the flag object correctly. Define a variable (say, ) with the following formula:
= If <Month> = Max(<Month>) In Report Then "Y" Else "N"
Now your primary formula would be:
= <Profit> Where (<Month Flag> = "Y")
Dwayne Hoffpauir (BOB member since 2002-09-19)