Total in Expression

[QFanatic]

hi guys

1. Please explain to me what the 'Total' in the following expression means...

2.  I am specifying REQ_HOUR -= {'NULL'} in the Set Expression ,..would this hardcoded 'NULL' field also get excluded in the Total part? if not - how can I get that part explicitly excecuted in the Total...?

avg({$<PERIOD={$(vMaxMonth)},REQ_DATE=, TYPE_GRAPH = {'HOURLY'}, REQ_HOUR -= {'NULL'}>}total <WKDAY,REQ_HOUR> HOUR_VOLUME)

thanks

[Saravanan_Desingh · Accepted solution]

TOTAL consider all selections you make. But ignores the row in the Table. The Aggregation will be done across the rows.

You can search in the community for more details.

[Saravanan_Desingh]

Just noticed.
Are you trying to remove the NULL values for REQ_HOUR, with the below code? Sorry its wrong.

REQ_HOUR -= {'NULL'}

 Use below. It is equivalent to Not IsNull(REQ_HOUR).

REQ_HOUR = {"*"}

[QFanatic]

Hello,

I've built in a line in my code that says if(isnull(REQ_HOUR),'NULL',REQ_HOUR) as REQ_HOUR to try and 'catch' that null field.