Sum values only if value in other column is below.

[Woojtek_96]

Hello, 

I want to sum Price only if agency number is lower than 70000. Now I make something like that:

sum({$<[Agency number]={"*"}>} Price) * 0.0407

I know this will sum all values coz of "*", but could anyone tell me how to modify this? to make a solution which i want.

i have to make a variable? I tried <, >, =<, >=, instead of = but i didn't work.

Thanks for all help

Greetings

[sunny_talwar · Accepted solution]

This

Sum({$<[Agency number]={"<70000"}>} Price) * 0.0407

[Woojtek_96]

It works

Thank you very much!