Reports not running out of Design

[Guest]

I have a report that I am trying to run.. The string looks something like this:
=Sum(IIf([BU Month Name]="Jan",[Consumable Baseline],0)+IIf([BU Month
Name]="Feb",[Consumable Baseline],0)+IIf([BU Month Name]="Mar",[Consumable
Baseline],0)+IIf([BU Month Name]="Apr",[Consumable Baseline],0)+IIf([BU Month
Name]="May",[Consumable Baseline],0)).

When I add month of June- the report fails. If I take out May or any other
month and run it with June the report runs succesfully. It is almost as if
the IIF statement is too long. Can this be possible.
Any help would be greatly appreciated.

Regards
kiki

 

[Guest]

That is the problem. There is a limit to the number of IIf statements that
can be embedded, but I don't remember what it is.
What does the underlying table look like and what are you trying to
accomplish? Maybe there is another way.