Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Rank of a record

nikos_1283
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

Hi everyone,

First, I apologize for my english level... I'm french and, whereas I read english very well, I'm very bad when I have to write something in. So, sorry, but I hope that you could help me here :smile2:

So, I've made a database with 7 tables. This is an estimate system with a customer and a product database. What i want to do is to create a field in my Customers table that displays me the rank of the record in the table. I have a Total invoices field, and I want this field be the "ranker" (If customer A has 2 000€ of total, customer B has 3 500€ and customer C has 500€, I would like that Customer B rank field shows the number 1, the A shows 2 and then the C rank field shows 3.).

Merci beaucoup de votre aide ! and sorry for this "arranged" english :crazy2:

I don't know the answer to your question, but if it's easier for you to communicate in French, this is a good place:

(Je ne sais pas la réponse sur votre question, mais si c'est plus comfortable pour vous de discuter en Français, vous pouvez essayer ce lien: )

http://www.fmsource.com/forum/

  • Author
  • Newbies

Thanks, I'll give it a try

Merci !

Create an account or sign in to comment

https://fmforums.com/topic/53620-rank-of-a-record/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.