Using IIF in text field in report

[herbertioz]

Hi!

I need some help on If statements...

=IIf([GevinstTap]=True;Sum([AntallPips]))

GevinstTap is a true/false field and AntallPips is a number field.

I want to calculate the Sum of all fields who are True.
Can someone help me? I know it is a simple thing..but

Herbertioz

 

[pbaldy]

I'd reverse it:

=Sum(IIf([GevinstTap]=True, [AntallPips], 0))

 

[herbertioz]

Yes.. Thanks!

the new code that works:

=Sum(IIf([GevinstTap]=True;[AntallPips]))

 

[pbaldy]

Happy to help!