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.
 
Back
Top