Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
You can´t use an aggregation inside other aggregation without using AGGR()
Your expression is SUM(([WORKLOG.TIMEWORKED] / count(WorkingDay))
maybe
SUM( {< [ACCOUNT_TYPE]={'Change Request'} >} [WORKLOG.TIMEWORKED] )
/
($(vFTE))
regarding the error you can read here