Expression Help

[abhaysingh]

I have Table in which

Customer code          customer Name          Pre-Tax Value for CY          Pre-Tax Value for LY

01                                        X                              100                                        110    

02                                        Y                               150                                        140

03                                        Z                               50                                           60

04                                        A                               10                                           08

05                                        D                               200                                        190

On the basis of Pre-Tax Value I Want RANK calculation for CY and LY.

e.g. For CY    Pre-Tax value CY              RANK

                         200                                   1

                         150                                   2

                         100                                   3

                           50                                   4

                          10                                    5

[jyothish8807]

Hi Abhay,

Create a  two expression new field .

=Rank(Pre-tax Value CY)

=Rank(Pre-tax Value LY)

Regards

KC

[abhaysingh]

hi Jyothish

Not working, already tried

[jyothish8807]

As per your data it should work.Can you share your app?

Regards

KC

[anbu1984]

Rank(TOTAL [Pre-Tax Value for CY])

[abhaysingh]

sorry not working

[maleksafa]

can you upload a sample document maybe we can help you better.