Descending

[Steve95]

Hi All

I need to know how to make a field in a formula to output in descending.......

The formula is a 'if the else' statement so if it meets the 'then' criteria I want the output in descending....

Many Thanks in Advance...

tc

 

[pelajhia]

A formula can output 1 value per detail line.

How many values at once are you trying to order?
Are these numbers or alpha-numeric?

If I understand the problem, one solution might be to analyze the values to understand which is greater, convert to strings and then concatenate them in that order.

Is this the sort of thing you are thinking of?

if {field1}> {field2}
then
totext({field1})+", "+totext({field2})
else
totext({field2})+", "+totext({field1})

The above is a very simple example; please provide more details of the input data, where the formula is to be evaluated (detail line?) and what the desired output should look like.

 

[MisterMo]

Create another formula field eg. {@SortingBy} with the following code

if {@YourFormula} = 1 then

{@YourFormula}

else

''

then create a group and group by {@SortingBy} in ascending order.

please give more details regarding formulas, it makes things easier

if there is any value the group will work otherwise it will be ignored.


Mo

 

[Steve95]

as typical.......Business abandon idea and have change their requirements.......

Many Thanks....