Calculated dimension not working

[devarasu07]

Hi All,

below expression not working in calculated dimension but it's working in expression. kindly advise me. thanks

=if((Count({<Year={'*'},Week={'*'},Type_ID={'RO'}>} distinct OrderQty))>0, 'Repeat', '-')

Note: used pivot table

Regards,

Dev

[Anil_Babu_Samineni]

Would you provide sample to work, Why it's not working because you can't do direct count in Dimension level. Might require aggregation function. Can you share the application?

[devarasu07 · Accepted solution]

Hi Anil,

Issue resolved,

=Aggr(if((Count({<Year={'*'},Week={'*'}>}distinct OrderQty))>0, 'Repeat', '-'),ArticleNo)