Jump to content


  • Posts

  • Joined

  • Last visited

darno's Achievements


Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  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 go to related record, showing only related records (for the sector) and then set the counter from 1 to 30, commiting records each time, I can build my graph! So I wouldn't need the DataReference2004_Frequency TO anymore! When I am finished, I give some more feedbak and, hopefully, close this topic.
  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 = Min(Parameter1) Parameter1 is a calculation field = field1 - field2, where field1 and field2 are numbers and where SpreadParameter1 is a calculation field = MinParameter1-MaxParameter1 I try to get the results in a calculation field in the table Viewer that would get the count of the values for the sector and only for the ones that have the indicated position defined in gCounter, that is = Count ( DataReference2004_Frequencies::Parameter1 ) Yet it works when I set it to = Count ( DataReference2004::Parameter1 ) but then I get the results for all the sector, and not the count of the portion that goes in the sector AND appropriate position... I checked, and there should be results that match both the criterias... so there should be a result What's wrong?
  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 a Value list: "CalculatedReference". Using the "Result" calculation field in the table "Codes", it seems that I can get the appropriate result... The first Problem: I would need this result to be in a field of the "Sommes", "prevSommes" and "prevprevSommes" tables, as I need the result also for the previous Financial States and not only the one being edited. However, I placed a similar calculation field in the "Sommes" table, and it returns "?" The second problem: Some values defined in the codes are determined from the previous financial states results, as the 6108, 6208 and 6308, that are "the adjusted stocks values for the previous financial year". I just have no idea how I could do it! For now, the terms that refer to the previous financial state are identified with a leading "p" in the "Formule" field (table "Codes"), but nothing is functionnal. Any idea? Thanks. FStests.zip
  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 corresponding Financial State; the Slots contains a global field that identify the "current" F/S), but in some of the calculations, the codes will refer to the previous financial state... so I thought I could identify this by appending a "p" to the code in the formula... is it a good idea? Anyways, it's not really the issue that is discussed here....
  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 "evaluable" equation from the sets of calculation steps... From what I have, I can probably easily build an equation that looks like the one you showed, but with the actual values instead of the codes (How? I'm not sure... I am gonna think about it tomorrow! so if you have an idea by that time...) And that would leave me with something like: 568+ 79956- 78+ 4/ (or: +568 -79956 +78 /4, keeping in mind that the parenthesis are missing, so it can't be evaluated the same way... and I don't care if they are unnatural for most people as long as I can get my result in a field somewhere!) As the terms would always be in the right sequence, I'm sure there is a way to evaluate it... any Idea? Will I have to build a custom function or is it possible via a normal calculation? Finally, I will probably have no need of a script. It looks like everything is done by calculation, which is great because it always updates...
  • Create New...

Important Information

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