Cannot use aggregates in complex filters: filter problem

building reports desktopintelligence
1

Dear all,

I have a report with complex format, there is a formula : =RunningSum( - ) for each ) +

Now I need to sort out the result of is below 0 only, in the global filter field I try to make a dynamic filter as: = Min()<0 however I was alerted “Cannot use aggregates in complex filters”, even =<0 is failed.

Could anyone help me to fix it or give me thread/instruction to achieve.

thanks a lot.
Best regards.

marc-mk peng (BOB member since 2007-06-29)

2

First create a variable A = . Then use A in your filter as A < 0. After the filter is created, change variable A to Min(). It should work. Outsmarting BO. :lol:

vinod_menon :india: (BOB member since 2007-04-09)

3

Thanks vinodmn for reply, but variable A is automatically identified as Measure type and can not be changed, also can not be applied in the filter as its source is aggregated , a pity it doesnot work.

Any more idea? thanks a lot.

marc-mk peng (BOB member since 2007-06-29)