Sending value of zero using DBS

[Neil Wilson]

Can anyone tell me if it is possible to send a value of zero using DBS, whenever I try this formula is ignored?

64bit v9.0

Thanks

[David Usherwood]

Should work - I can think of many times I have used it in the past.
You could try making the formula DBSW - this is meant to be more efficient when you are sending lots of data.

[mattgoff]

Works for us. Note that empty cells aren't sent, so you need to have an explicit zero in the cell. Also, just a (probably unnecessary) caution to David's recommendation for DBSW: make sure nothing in the DBSW is dependent on another DBxW as all of them will get batched together (breaking the dependency tree) which may lead to incorrect or inconsistent results. For this reason, I never use DBSW.

Matt

[jim wood]

This has worked for me in the past. Matt is right, you should watch your calculation order especially when using DBSW in combination with DBR(W).