Error in expression: Nested aggregation not allowed

[pablomind]

Good morning, I'd been trying to make this expression work:

SUM( {<  [ACCOUNT_TYPE]={'Change Request'} >}  ([WORKLOG.TIMEWORKED]/$(vFTE)))

where vFTE its

Count( {<  WorkingDay={'Work'} >}  WorkingDay)*8*$(vMODFTE)

Why the expression gives me back this error and doesnt show the result?

[vishsaggi · Accepted solution]

Can you send a sample app or all the variable expressions used. Did you use text objects and tried displaying those variables are they giving any values in the textobject ?

Try this?

= SUM( {<  [ACCOUNT_TYPE]={'Change Request'} >}  [WORKLOG.TIMEWORKED]) / $(vFTE)

[Clever_Anjos]

You can´t use an aggregation inside other aggregation without using AGGR()

Your expression is SUM(([WORKLOG.TIMEWORKED] / count(WorkingDay))

[maxgro]

maybe

SUM( {<  [ACCOUNT_TYPE]={'Change Request'} >}  [WORKLOG.TIMEWORKED] )

/

($(vFTE))

regarding the error you can read here

Aggregations and Function Classes