Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, in my Stock data I have many lines with an ONHAND value that is negative (IE: -100,-50....).
I would like to sum up the value of these items by multiplying it by the cost of each stock line.
However the formula does not seem to work, I'm not sure what I'm doing wrong.
Formula I'm using: IF( [ONHAND]<0, (sum( [ONHAND] * [COST] )) ,0 )
Hi,
Create a field in the load script like [ONHAND] * [COST] as VALUE
apply the following expression in the chart
sum ( {<VALUE = {'<0'}>} VALUE)
Regards
Vikas
I cam right with a slight edit to the formula,
=sum({< [STOCKHOLDING] ={"<=0"}>} [STOCKHOLDING] )
Hi,
Create a field in the load script like [ONHAND] * [COST] as VALUE
apply the following expression in the chart
sum ( {<VALUE = {'<0'}>} VALUE)
Regards
Vikas
Hello,
I have done as suggested and created a field called STOCKHOLDING and did my formula as belo, but unfortunately the result is 0, when it should be -1.5M
(sum({<[STOCKHOLDING]={'<0'}>} STOCKHOLDING)
Can you post some sample data what you are using ?
Vikas
I cam right with a slight edit to the formula,
=sum({< [STOCKHOLDING] ={"<=0"}>} [STOCKHOLDING] )