cancel
Showing results for 
Search instead for 
Did you mean: 

Sumproduct problems in Xcelsius???

Former Member
0 Kudos

Post Author: gmatriix

CA Forum: Xcelsius and Live Office

Hello All,

Can anyone tell me why a supported function (sumproduct) gives me a #Value! error when I preview the dashboard. I works fine in excel. the formula I am trying to use is:

=IF(OR(B18="",C18="",D18=""),"",SUMPRODUCT(('Query Data'!J2:J5000=Calculations!B18),('Query Data'!K2:K5000=Calculations!C18),--('Query Data'!M2:M5000=Calculations!D18),'Query Data'!N2:N5000))

I don't understand why it is not excepting this supported formula........?????

Any Ideas??????

Thanks

gmatriix

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: amr_foci

CA Forum: Xcelsius and Live Office

note that not all the Excel functions supported by Xcelsius

please check http://infomps.tempdomainname.com/help/xcelsiusHelpXLV4/source/ref_tool_xlfuncs.htm

and check this for more information about xcelsius

http://infomps.tempdomainname.com/help/xcelsiusHelpXLV4/source/ug_FAQPro.htm

good luck

Amr