on 09-16-2008 6:03 AM
Hi Friends,
I have a formula which is as below,
Equal
Order qty == ( SUMCT 'Invoiced Qty');
which result 1 if condition is true.
The formula results are fine. When i put condition as
Equal not equal to 0 the query is returning no value.
Can you please help in this how to work out this type of situations.
Regards,
aanand
We need to restrict the drill down of characteristic which is last in columns.
Regards,
aanand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
sorry for not mentioning...
i am in 3.5...
Even i tried in BI 7 Server i couldnt able to get the result.
Regards,
aanand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Is there any alternative to SUMCT ?
Regards,
aanand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't know if your condition has to be triggered by the users or always valid.
For Always valid, just multiply your other key figures by the boolean formula you created ... Result should be only the valid lines.
I would say the SUMCT and the Condition can maybe have a collision, since the SUMCT can change in case of apply of a condition.
You maybe can try to create KF which are exception aggregation. Depends really on the report you would like to do.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.