SUM on alias in a REPORT

[Frank]

Is there a way to do a SUM calculation in a report footer [or group footer]
of a column field alias of a particular query?
On report: =SUM([MarksAlias]) ???
The alias in the query contain the following statement in the column field:
Exampl: MarksAlias: IIF([Memory]=â€Aâ€,â€0â€,IIF([Memory]=â€Bâ€,â€0â€, [Marks])
Thank you

 

[Marshall Barton]

Is there a way to do a SUM calculation in a report footer [or group footer]
of a column field alias of a particular query?
On report: =SUM([MarksAlias]) ???
The alias in the query contain the following statement in the column field:
Exampl: MarksAlias: IIF([Memory]=”A”,”0”,IIF([Memory]=”B”,”0”, [Marks])

If you want to sum something, it must be a number type.
Since you have quotes around the numbers in the IIfs they
return Text.

Just remove the extra quotes:

MarksAlias: IIF([Memory]=”A”,0,IIF([Memory]=”B”,0, [Marks])