Condition is not working on Boolean Formula

[former_member204514]

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

[former_member204514]

We need to restrict the drill down of characteristic which is last in columns.

Regards,

aanand

[former_member204514]

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

[former_member204514]

Hi,

Is there any alternative to SUMCT ?

Regards,

aanand

[Former Member]

Yes, exception aggregation (as in my previous post).

[Former Member]

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.