Hi
I thought I would share this:
I had a sheet where I made some fields "mandatory" using the Settings- Sheet Properties-Triggers and from here I set the Select In Field.
I then had a number of formulas like this with the "mandatory" settings specified again.
Sum({$<Classification = {'Clinical'},IsHoliday = {'0'},IsWeekEnd = {'Remove Saturdays'}>}DurMins)
There was then a week of 0 values (ie Classification was NULL) and the figures were incorrect.
I then deleted the mandatory sheet settings but kept the formulas and the figures were correct.
so BEFORE: I could see what the selections were in the Current Selections Box
but now I cannot. Is there a way of displaying the SET ANALYSIS values?
Jo
This qvw file will show what I mean regarding the Current Selections box
Message was edited by: Jo Tedesco