Problem wit sum and iif!!!

S

Seawolf

Joined
Feb 18, 2010
Messages
1
Reaction score
0
Hi,

I have problem with sum and iif.

I have in text box following:

=IIf([Title]="Prodajna provizija";[Vrijednost projekta neto]*[Postotak];IIf([Title]="Zadovoljstvo klijenta";([Vrijednost projekta neto]+[Budget])*[Postotak];IIf([Title]="Studija sluèaja" And ([Vrijednost projekta neto]+[Budget])*[Postotak]>800;800;([Vrijednost projekta neto]+[Budget])*[Postotak])))

and everithing is calculated fine, but when I want to make sum of those data I receive "#Error" mesage.

=Sum(IIf([Title]="Prodajna provizija";[Vrijednost projekta neto]*[Postotak];IIf([Title]="Zadovoljstvo klijenta";([Vrijednost projekta neto]+[Budget])*[Postotak];IIf([Title]="Studija sluèaja" And ([Vrijednost projekta neto]+[Budget])*[Postotak]>800;800;([Vrijednost projekta neto]+[Budget])*[Postotak]))))

Thanx in advance on your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transform Access SQL to SQL server 2005 or SQLExpress 8
Using iif Null and 0 5
System Resource Exceeded/Query Too Complex 4
IIF Expression 1
Complex Query not working on report 2
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Access Query problem 1
Nested IIF expr not evaluating 2nd condition and beyond. 2

Top