How to transfrom a set expression to a dimension with string return instad of ONE and ZERO

[Applicable88]

Hello,

I have following expression:

count(if(num(floor([EntryDate]))<num(floor(Date(today()-30))) and isnull([DispatchDate]),OrderNO)

It works well as a measure, but not when I want instead of one and zero return as a Dimension:

=aggr(count(if(num(floor([EntryDate]))<num(floor(Date(today()-30))) and isnull([DispatchDate]),OrderNO)),OrderNO)

still get 1 and 0's . 

I also tried this:

if(count(if(num(floor([EntryDate]))<num(floor(Date(today()-30))) and isnull([DispatchDate]),PRONum))>0,'Yes','NO'))

I wan to instead return with 'Yes' and else 'No'

Any ideas?

Thanks a lot

Best. 

[tresesco · Accepted solution]

@Applicable88 

You need to combine the two (that you tried separately). Try something like:

If (Aggr(Count(.......) ,..)>0, 'Yes', 'No')