Removing - (Hyphen) results with in a Text Object

[#1]

Hi, I have the following Expression calculating the result of the top value in a list of activities with values in a Text Object.

In my data there has been a - (Hyphen) transfered with all the results.

=FirstSortedValue(Response_Level_2, -aggr(sum({$<Question_List_ID={4},Response_Level_2>}Ans_Minutes),Response_Level_2))

How can I exclude the - (Hyphen) results from the results?

Thanks

Rob

[#2]

Can you provide a sample file? What do you mean by the hyphen results?

[#3]

Sorry, just been reading other dicussions and the -(Hyphen) I see represents Null or values with 0

Does this help with the request

I can't add a sample file - sorry

[#4]

You can suppress the null values.  In Chart Properties > Dimensions > Select 'Suppress when value is null':

[#5]

Hi yes I have been using this for the charts I have created, however how could I do this with a text object where there is not Supress option.

This is why I'm trying to find a solution in the expresion I'm using.

Thanks for your continued support.

Rob

[MayilVahanan]

Hi

Try like this

=Alt(Sum(Sales),0)

If there is no values in sum(sales), i.e. null value( hypen) means, it display zero..

Edit:

want to Display blank means,use

Alt(Sum(Sales),'')

Regards,

R.MayilVahanan

[#7 · Accepted solution]

Hi I have continue to play with the expresion and have the answer.

=FirstSortedValue(Response_Level_2, -aggr(sum({$<Question_List_ID={4},Response_Level_2-={'-'}>}Ans_Minutes),Response_Level_2))

By adding      -={'-'}        to the expression it has given te rsult I needed

Thanks for all of your suggestions.

Rob