Where/If statement in loading script

[Dayna]

Hey All,

I was sure this is an easy thing to do, but it's driving me crazy!! So, any help will be appreciated.

Basically, we have two sites, 110 and 120, and what I am trying to achieve is that if the sold qty is less than 0 for site 120, I don't want to show it! (I do for the ones in 110). I was thinking an if statement or a where clause in the loading script.. but nothing is really giving me the results!

Please help!

Kind Regards,
Dayna

[#2 · Accepted solution]

Try using the following expression to ignore the sold quantity for 120 when it is less than 0:

=if([Sold Quantity]<0 and Site =120,'',[Sold Quantity])

[Dayna]

Perfect - many thanks!