Page 1 of 1
Sending value of zero using DBS
Posted: Tue Dec 23, 2008 4:54 pm
by 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
Re: Sending value of zero using DBS
Posted: Tue Dec 23, 2008 6:04 pm
by 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.
Re: Sending value of zero using DBS
Posted: Tue Dec 23, 2008 6:20 pm
by 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
Re: Sending value of zero using DBS
Posted: Wed Dec 24, 2008 8:13 am
by 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).