Count if Sum(x)> 5000

[#1]

Hi,

I am trying to write an expression where I want to calculate the number of distinct PO's with Line Amount less than or equal to $5000.

I believe I need to Aggregate the [Line Amount] spend by [PO Number] to list all such PO's in straight table.

I'd appreciate if I could get the best method/syntax to produce this result?

Thank you in advance.

[MarcoWedel]

Hi,

your Total Amount for POs having Line Amounts between 5000 and 10000 could be:

=Sum(If(Aggr(Sum([Line Amount]), [PO Number])>5000 and Aggr(Sum([Line Amount]), [PO Number])<=10000,Aggr(Sum([Line Amount]), [PO Number])))

hope this helps

regards

Marco

[#3]

Marco,

Thank you for the response. Could you kindly share the .qvw for this?

Appreciate your help!

Regards,

Deep

[MarcoWedel]

Hi,

qvw is already attached to my previous post.

regards

Marco

[simenkg]

=Count({<[PO Number]={"=sum([Line Amount])<5000"}>}Distinct [PO Number])

[#6]

Marco,

Thank you!

This worked perfectly!

Appreciate your help!

Regards,

Deep

[MarcoWedel]

You're welcome

Regards

Marco

[Anonymous]

Hello Jonathan,

It was very useful.

thanks