Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart in my application which uses the following expression and works great.
sum(aggr(count(distinct CONTRACT_ID),C_MCH_CODE,C_MONTH))
However - what I would like to do is stop this expression being a affected by the selection of a certain field (that field being a date called "task_end" )
I can sucessfully do this to a certain point by using :
sum({$<[TASK_END] = >}distinct CONTRACT_ID))
However when I try to include the aggregation and count to the formula I cant seem to get the set analysis to stop the "task_end" field from affecting my expression.
Any help would be greatly appreciated!
Thank you!
Bryan
because of the second calculation for aggregation fields you have to exclude selection in field TASK_END also
sum({$<[TASK_END] = >} aggr(count({$<[TASK_END] = >} distinct CONTRACT_ID),C_MCH_CODE,C_MONTH))
because of the second calculation for aggregation fields you have to exclude selection in field TASK_END also
sum({$<[TASK_END] = >} aggr(count({$<[TASK_END] = >} distinct CONTRACT_ID),C_MCH_CODE,C_MONTH))
Hi Martin,
Thanks for your quick reponse - makes perfect sense and worked great.
Regards
Bryan