Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About darno

  • Rank
  1. Ok, I managed it a simpler way. Instead of adding scripts and table occurences, I removed one TO. it was simpler than I thought. I just put the gCounter field directly in the DataReference2004 table, and defined two more fields: lowerlimit and upperlimit, that update everytime I change the gcounter value. Then, I added another field, always in the same table, that calculates if the current record is included between the two limits, and returns 1 if so, and 0 if not. A last summary field makes the total of these, which is the frequency I need. I am not done yet, but I guess that if I just
  2. ok, I think I see how it works... The same logics should apply to my solution... I give it a try and then I give you a feedback. The weirdest thing is how you set up "the breaker" with your "paramters". At first, it got me confused!
  3. It is based on a summary field... of course it is not indexable, but I need to find a way to get the value! Big deal... it's a frequency (count summary on certain conditions), I can't see how i can get it otherwise... The database is pretty large, and contains confidential data, so all I can do is give you this other picture that should allow you to understand what I am trying to do. It is actually pretty simple. Then all you can do, I guess, is give me a feedback of your understanding, and some clues if you have any. Thanks
  4. Ah! so the three little triangular lines indicate indexing, right? and when there is a vertical little bar on both occurences, the relation does not work... still right? it's good to know... i've been wondering for a while! But that doesn't help me though. I am still stuck!
  5. In the following example, I can easily get aggregate calculation results for the table occurence "DataReference2004", that indicate me stats about the records that match gSecteur... but I can't when I add a criteria in the relation that is based on a calculation field (GraphPosition30Parameter1) returning a number for each record and a global field (gCounter) in Viewer which contains integer numbers from 0 to 30 where GraphPosition30Parameter1 = Floor ( Abs ( (MinParameter1 - Parameter1))/(SpreadParameter1/30)) and is unstored, and where MinParameter1 is a calculation field
  6. mmmmh, I just found out that the entire thing doesn't work at all! even when I link the tables prevsommes and prevprevsommes to the global fields that contain the date of the previous financial states, the result returned in the portal does not correspond to the values of the previous financial state! If no one explains to me by monday, I will decide that I am not smart enough to understand how Filemaker works and I give up!
  7. Ok... a nice challenge here: 2 different issues in a pretty complicated database. I attach the file right away. Description: It is supposed to be used for entering financial states data: using the "Viewer" layout. The "codes" table define the elements that are entered manually or calculated. It contains a "Formule" field that determines how every code is calculated. When it is simply entered manually, the "Formule" only contains it's own code. The codes contained in "Formule" are duplicated in the "CalculationSteps" table, used as the reference for matching the data and the formula, in
  8. Yet another problem.... I can only get the result in the codes table. I would need the result to be in the sommes table since there is one result per code, per financial state... but it doesn't work and I still can't get why! --> I just copied the result field to the sommes table... and it returns "?". So I changed "formule" for "Codes::Formule" in the calculation... but it still returns "?" Do you want me to send you the file once again? I think I am about to give it all up!
  9. Do you mean "just take 30 seconds to search on the web and you should come out with some ideas"? Because It's just what I wanted to hear... Now I got it written! Thanks
  10. Mmmmh! I should have seen these errors at first glance... instead, I was once again wondering from the left to the right what was wrong in my databases........ Thank you I never used custom functions before... Will it work in the runtime application generated by Developper tools?
  11. I need to create grahphs that would look EXACTLY like this one, i.e. with the vertical lines etc. Do you know of a plugin or whatever that can do it automatically from Filemaker databases, or whatever databases (Oracle?)... graphic.bmp
  12. .... Actually, I do get a valid looking value list... Maybe it's another problem, but I did exactly the same and it returns "?" here, I send you the whole thing... if you like, you can try to figure out what the problem is calculationproblems.zip
  13. Aaaah! This would work like a charm... but in your example, the values are inserted manually so you can make the value list... mine are summary field results so the value list does not work.... I can't see how to make it work!
  14. wow... feels like I'm getting close to a working result! Did you build this sample just for me? And why do you set it to "unstore" ? And Why do you want the calculation result to be text and not number? Ok, I get another little problem: when I build the value list, I get this error message: "this value list will not work because the field "Definitions" cannot be indexed. Proceed anyway?" What's wrong? And another little problem I anticipate: For now, all the calculations referred to the same Financial State (every sum of values is related to a Slot, but also to a
  15. That's why I managed to separate them in NUMBERED calculation steps... What I did is that I added a field "operator" to the calculation steps table, so that the codes don't have any prefix... Wow! that said, I think I got it! This gave me an idea: From every Calculation Step entry, I can get the associated slots' sum just with an aggregate function... this means I can match every equation's code with its value. I just have to put it in a field of the calculation Step table and.... mmmmh not so simple; Actually, the task now becomes to "rebuild" an "evalua
  • Create New...

Important Information

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