Filter the Negative Values from a Calculated Expression

[Anonymous]

Hello!

I have a calculated expression  =sum(Qty)/Sum( Total<Material,FQr> Qty) ...How can I filter to show only the  negative values if  my calculated expression is less than the dimension field  "Target"....      If(sum(Qty)/Sum( Total<Material,FQr> Qty)  < Target)

Hope someone can help me on this.

Tks.

[Anonymous]

Hi!  Marco,

Thank you so much...it finally worked.

Tks.

[Anonymous]

HI!  I actually want to flag as "answered"...but there is only helpful in the  action drop down...

Rgds...

[MarcoWedel]

Try in the thread itself, not in the in-box.

Regards

Marco