Conditional count of field in text object based on expression held in variable.

[Anonymous]

Hi,

I have a text object (# of IRs) that I want to display the distinct count of CHANGE_ID based on an expression where the CHANGE_ID's TOTAL SCORE is <= 7. The expression works in a Pivot Chart but when I put the expression into a variable (v_total_score) and bake that into the text object, it only counts when you drill to one CHANGE_ID.

The below image shows what I'm trying to do.

[Anil_Babu_Samineni]

May be this?

Count({<CHANGE_ID = {"=sum(TOTAL CHANGE_ID)<=7"} >} distinct CHANGE_ID)

[Anonymous]

Hi Anil,

When I use Count({<CHANGE_ID = {"=sum(v_total_score)<=7"} >} distinct CHANGE_ID) it counts all CHANGE_ID's and doesn't filter out those where the TOTAL SCORE is <= 7.

I'm wondering if I need to use Aggr() in here somewhere?

Thoughts?

Thanks,

Jason

[Anil_Babu_Samineni]

I don't think you need any aggregation over expression. Can you show where and how you are declare the variable

[Anonymous]

See below. Something to consider, the v_total_score variable works in a text object when a single CHANGE_ID is selected but shows '-' when more than one is selected.

[vinieme12]

Try

=Sum ( TOTAL  AGGR( YOUREXPRESSION , CHANGE_ID ) )

[Anil_Babu_Samineni]

Please attach file to test

[Anonymous]

Hi Anil, did you attach it?

[Anil_Babu_Samineni]

No, I am asking please attach some sample application to test

[Anonymous]

Here you go.