on 09-27-2007 8:33 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.