Skip to Content
0
Mar 04, 2009 at 11:57 PM

DSUM Excel formula does not work properly

22 Views

Hi Xcelsius Gurus,

I have a problem that seems to be a bug in Xcelsius 2008. I'm using DSUM Excel formula that adds numbers in a column of a database that match to specified conditions....so... that formula works O.K. in my Xcelsius Spreadsheet and Canvas in design mode. But, if I go to preview mode does not work properly.

I have already applied Fix Packs 1 and 2 in my computer...

the formula is:

=DSUM(Query_4,$AM$14,Inprocess)/1000

the Database or list are:

Query_4 =Booking!$B$14:$AP$855

the paramenters declared as follows (Inprocess):

Month | Opp Owner| Region | Opp Sales |Opp Status| Opp Phase

Jan * Mexico * In process <D

Mar * Mexico * In process <D

Feb * Mexico * In process <D

Best Regards

Arturo

Edited by: Arturo Sanchez on Mar 5, 2009 1:23 AM