How do I set a formula to look at certain values without selecting the values in an object?

[#1]

Hi again,

Mu utilisation figures have a couple of flags, one indicates if the time is chargeable, a second indicates if it is utilised.

I have some charts that need to plot the percentage of chargeable utilised time, but in the expression I am using the following formula:

=IF(CHARGEABLEFLAG='Chargeable' AND UTILISED='Utilised',
SUM(DAYS)/NETWORKDAYS(MIN(START_DATE), MAX(END_DATE)))

This used a monthly picker at the top of the screen to calculare the working days involved in the time period chosen.
The charts only display data if I select 'Chargeable' and 'Utilised' from my list box objects.
How would I get them displaying that information constantly, regardless of what data is chosen?

Thanks in advance,

Matt

[#2 · Accepted solution]

Hi,

The If condition check should be used inside the SUM() function.

Something like this..

sum(IF(Chargeable='Chargeable' AND Utilized='Utilized',Days))

Regards,

Silvia