Jump to content
Server Maintenance This Week. ×

Im half way there... now what?


This topic is 7827 days old. Please don't post here. Open a new topic instead.

Recommended Posts

hi,

I have a simple DB with a few normal fields and 2 calc field:

Totaalwaarde -> Calc -> Unstored. =count(waarde::waarde)

Summary -> Calc -> unstored=(Max(totaalwaarde)

Totaalwaarde calcs the number of times the same value is added in the database. Its also searchable (so it can be used in a -find request). But how do I set a field that only selects 1 record instead of all. Let me clearify:

10 records with 'A' as a value in 'Waarde'

5 records with 'B' as a value in 'Waarde'

Totaalwaarde results in: 'A'=10 and 'B'=5

..All 10 records containing 'A' have that mark so if i do a find on the highest 5 (-max=5) it will show all 5 records from the 'A''s. Instead of ranking 'A' as 1, 'B' as 2 etc.

So i want to omit all in the same range (waarde) but one... or something ...

ThX jp

snippet of the htm I use:

[fmp-inlineaction: -db=test2b.fp5,-sortfield=summary,-sortorder=descending,-max=5, -find]

[fmp-record]

[fmp-field:recordid] -- [fmp-field:waarde][/fmp-record][/fmp-inlineaction]

Link to comment
Share on other sites

This topic is 7827 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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