I have a form that the user answers

[timISST]

I have a form that the user answers 1 question (x) or the other and the one they dont answer gets disabled. I have that working. here is my issue I am making a report that calculates an average and I cannot figure out how to make the report ignore the disabled field. any help would be greatly appreciated.

 

[timISST]

I tried using this to set the question to 0 but nothing happened.
IF x = '1' then '0'
else if x='2' then '0'
else if x='3' then '0'
else to number y
that didnt do anything either.

 

[hilfy]

How is the data stored for your report? In other words, what is the table structure?

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com