I have a report as shown below:
School Year Member EducLevel Pledge Invoice Payment 18-19 Neil College 2300 19/3/3 500 Marites HighSchool 1100 19/2/25 1000 Joeben College 2300 0 Teresa College 2300 19/01/01 1500
Pledge is a text box with formula =iif([educlevel]="College",2300,1100
The pledge text box runs properly.
What I need is to total the pledges. I entered the following formula =sum([pledge]).
When I run the report, it ask for an input, if you enter, it is blank. It is not properly running the formula.
Can you please help me.
Trident