I have the formula below... I only want to sum up the B Bal & G Bal field if the subsytem = CLS but I get "The expression you entered has a function containing the wrong number of arguments."
IIf([M_SUBSYS_ID]="CLS",SUM(Nz([B Bal])And Sum(Nz([G Bal]),"")))
can anyone think of why??
Last edited by jgomez; 05-07-2012 at 05:25 PM.
Hi
Yoy mean something like this?
=If([M_SUBSYS_ID]="CLS",SUM(Nz([B Bal])+(Nz([G Bal]),"")))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I get Syntax error (comma) in query expression "i=If([M_SUBSYS_ID]="CLS",SUM(Nz([B Bal])+(Nz([G Bal]),"")))'.
=If([M_SUBSYS_ID]="CLS",SUM(Nz([B Bal])+(Nz([G Bal]),""))
Or even better.
Would you like to upload a small sample workbook, for us??
Last edited by Fotis1991; 05-07-2012 at 04:46 PM.
Couldn't save & enter your formula... just enter it & you will get error message just take out the = sign & make sure you type in "iif" not "if"
I Can "open" your file.
It's says that is an ACCDB File
Sorry...
Got it! Its
Relationship Bal: IIf([M_SUBSYS_ID]="CLS",Nz([B Bal])+Nz([G Bal]),"")
& thanks Fotis!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks