Set expression when calculation is negative / positive

[hansvillo]

Hi,

Hi
I am creating an application that contains stock counts of a clothing branch.
I get an expression not working:

If the counted stock - the current stock is negative, add me the value of the products. 
This way I can know how many euros worth of clothing has been counted away (in a KPI object)
The field are:
Current stock (contains 1,2,3,4 etc) per itemnumber (unique)
Counted stock (Countains 1,2,3,4 etc) per itemnumber (unique)
Value field (per itemnumber, unique)

Can somebody help me with the set expression? 

[vinieme12]

can you post a some sample data in excel and expected output

it's difficult to visualize by just reading a description

[hansvillo]

Hi,

See attachment 🙂

In this case it is a negative difference. 

I want to make a if statement that sums the value if the counted stock level > Stock level.