Error in Script !!

[nikhilgarg]

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

[Colin-Albert]

Try

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

[nikhilgarg]

No result yet !!

[maleksafa]

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

[nikhilgarg]

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]

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

Regards

Anand

[nikhilgarg]

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

thanks

[maleksafa]

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]

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