Set Analysis -vs- sheet properties

[josephinetedesc]

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