Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Error in Script !!

HEy,

I want Sum Of values for customers whose values is greater than 1000.

I ahve used following expression , but nothing comes in starightt able.

What to do ??

Sum({<Customers = {"=rank(Sum(Values),4)>= 1000"}>}Values)

Thanks

13 Replies
Colin-Albert

Try

Sum({<Customers = {"=$(=rank(Sum(Values),4)>= 1000)"}>}Values)

nikhilgarg
Specialist II
Specialist II
Author

No result yet !!

maleksafa
Specialist
Specialist

=rangesum(if(sum(Values)>1000,sum(Values)))

nikhilgarg
Specialist II
Specialist II
Author

Hey thanks ,

I got it but i want the values to be shown in ascending order. How to do it ??

My output is :

432

444

654

78

How to do this ??

maleksafa
Specialist
Specialist

if you are using a straight table, simply go to the sort tab, select the expression and promote it to the top and then check only the numeric value with ascending order. you can remove the 'allow interactive sort' so that the users will not modify the sort later on.

its_anandrjs

Hi,

For sorting use the same expression in the sort order in the expression

Sortorder2.png

Regards

Anand

nikhilgarg
Specialist II
Specialist II
Author

Hey thanks. It works . But why to uncheck Interactive Sort ??

thanks

maleksafa
Specialist
Specialist

when you check the interactive sort, it will allow the user to change the sort by clicking on the expression column (you will say a small arrow next to the column name) so if you don't want the user to change the sorting you should uncheck it.

nikhilgarg
Specialist II
Specialist II
Author

Hey ,

Sorry but i didn't get you.

Did you meant to say that if i want sorting to be done my way then i should check the "Interactive Sort" option.

Is it so ?

Thanks