sum free from missing values

[#1]

AOA all

I want to get sum of amount free from missing or null values...

details:

I have a table with dimension of (stock_id,Partno,item) expression is =sum(bal_qty) as "Qty in stock"

Total shows in a table is 107556.

but when I go on table property and check supress null values in dimension tab for each dimension.

qty reduce to 98337  which is correct

now i want to show this 98337 value in text box.

kinldy adivce how to get purified value in text box because when i give =sum(bal_qty) in text box its shows 107556.

thnks

[#2]

no one to solve this??????

[MarcoARaymundo]

try this

sum({<stock_id={'0','$(=isnull(stock_id)=0)'}>} bal_qty)

[#4]

Hi,

I Didnt get your point can you upload your sample application. Hope it is helpful to solve this.

[MarcoARaymundo · Accepted solution]

Done!

[calvindk]

Here you go:

Sum({<stock_id = P(stock_id) >} bal_qty)

[ryanhicks]

Anders solution works for me.

[v_iyyappan]

Hi,

Use the expression like this in textbox

=Sum({<stock_id-= ('-') >} bal_qty)

Regards,

Iyyappan