Hello,
I have a problem with a pie chart in corgnos 10.
I have a message below :
The reference to the query item 'Avg Annual' forms a circular reference (La référence à l'élément de requête 'moy dos annuel' forme une référence circulaire).
Please does someone have the same problem ? how can I solve it ?
thank you
Hi,
What is [Avg Annual]? Is it a calculated item? If so, what is the expression it uses?
It sounds like you have a calculation which references an item in a second query, which in turn references an item in your current query, which in turn references an item in the second query, which in turn references an item in your current query... and so on to infinity?
MF.
Thank you for your response .
No I have only one query.
the 'Avg annual' is equal to [nb dos annuel]/[dif_annee]
and [nb dos annuel] is equal to if(trunc([DateC]) < trunc(?v_date?;'YYYY')) then ([Nb dos]) else (0)
and [diff annee] is equal to (_years_between (trunc(?v_date?;'YYYY') ; trunc([min_date];'YYYY')))
and finnaly [min_date] is equal to min([DateC])
I can't see anything that's obviously wrong there...the error message refers to 'moy dos annuel' which doesn't seem to be part of that calculation. Are there other elements in the query, or possibly a filter that might be causing the problem?
I can't quite see a circular reference, but years_between expects two dates, not two years.
Also, the expression trunc(date) <trunc(date, 'YYYY') doesn't make any sense:What does it mean to compare whether a date is smaller than a year? Either extract the year off cdate or compare years between when positive...
Hi,
trunc(date,'YYYY') return the first day of the year , for example mydate='21/05/2014' trunc(mydate,'YYYY')='01/01/2014'