Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you provide a sample file? What do you mean by the hyphen results?
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
You can suppress the null values. In Chart Properties > Dimensions > Select 'Suppress when value is null':
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
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
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