Sum of an iif statement

[tkm]

Hi

I have a problem in my report.

in my group section i've got a the following

field1_field2_________field3____field4
[name] [manorwoman] [amount] iif([manorwoman]=1;0:[amount]*1.05)

i can make a sum for field3 --> sum([amount]) no problem

Now the question

How can i make a sum for field4 ?

(I tried to name field4 p.e. amount2 and then sum([amount2]) but he keeps asking for 'parameter value amount2'.)


Thanks in advance for your answer.

Ciao

Tkm

 

[ecniv]

Hi

I have a problem in my report.

in my group section i've got a the following

field1_field2_________field3____field4
[name] [manorwoman] [amount] iif([manorwoman]=1;0:[amount]*1.05)

i can make a sum for field3 --> sum([amount]) no problem

Now the question

How can i make a sum for field4 ?

(I tried to name field4 p.e. amount2 and then sum([amount2]) but he keeps asking for 'parameter value amount2'.)


Thanks in advance for your answer.

Ciao

Tkm

Whats the Sql statement? add another calced field in there?
also isn't the iif meant to be

iif([manorwoman]=1,0,[amount]*1.05)

Vince

 

[tkm]

hi

yes the syntax is

iif([manorwoman]=1,0,[amount]*1.05)

but how can i sum this field ??

ciao


Tkm

 

[Rich]

=Sum(Iif([manorwoman]=1,0,[amount]*1.05))