Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can i remove null value from text box.......
i have use this expression
=num((sum(aggr(sum(amount)/sum(aggr((qty),model,product)),product))),'##.0')
Vipin,
Now I understand the issue. So which fields have NULLS? Meanwhile try this expression and if possible please post the sample QVW file.
=num((sum(aggr(sum({<amount={"*"}>} amount)/sum(aggr((qty),model,product)),product))),'##.0')
Thanks,
DV
Hi vipin
your question is not understandavle, pls clarify your question.
cheers
Pradip
I have pivot table there reflect sum of amount is 26 lacs same value i reflect in text box which is wrong but when i suppress null in pivot table then value are come 24 lacs which is correct but in text box value reflect in 26 lacs thats y i am asking how to remove null value in text box
Vipin,
Now I understand the issue. So which fields have NULLS? Meanwhile try this expression and if possible please post the sample QVW file.
=num((sum(aggr(sum({<amount={"*"}>} amount)/sum(aggr((qty),model,product)),product))),'##.0')
Thanks,
DV