Jump to content

djgogi

Members
  • Content Count

    583
  • Joined

  • Last visited

Community Reputation

0 Neutral

About djgogi

  • Rank
    member
  • Birthday 07/14/1966

Profile Information

  • Gender
    Male
  • Location
    Pisa, Italy

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. If you want to see all recs with marked_b set to 1 than the relationship should point from constant_n to marked_b and not viceversa (as you have set). Otherwise if you need to see all records with values of marked_b depending on current record value, you should create a relationship on the marked_b field itself Dj
  2. Simply define an relationship from "Countries" table to "Articles" table country-->address. Then create an calculation field (in Countries table) Count(TheAboveRelName::nameOfSomeNonEmptyFieldInArticlesTable) Dj
  3. I've just checked it. It does not respect the coversion table: In 14:31(=14.50) Out 15:03(=15.10) Diff=0.6 while your formula yields 0.5 Dj
  4. 10:45 (=10.80)-9:57(=10.00) gives 0.80 9:57 is 10.00 He, only, didn't make it explicit in his post! DJ
  5. Hour ( timeIn )+ Case ( Minute ( timeIn ) > 56 ; 1.00 ; Minute ( timeIn )>50; 0.90 ; Minute ( timeIn )>44; 0.80 ; Minute ( timeIn )>38; 0.70 ; Minute ( timeIn )>32; 0.60 ; Minute ( timeIn )>26; 0.50 ; Minute ( timeIn )>20;0.40 ; Minute ( timeIn )>14; 0.30 ; Minute ( timeIn )>8; 0.20 ; Minute ( timeIn )>2; 0.10 ;0) Dj
  6. Hi Substitute ( (10 ^ num)-1 ; "9"; Substitute ( (10 ^ num)-1 ; "9" ; textToRep ) ) Setting num to 404 and textToRep to "ask" took only 2 seconds in same configuration as your. BTW it's 163216 times repeated word "ask"
  7. oops! I didn't check it It will work. dj
  8. It didn't have time to do the conversion. If you split the calc, ie create test=(10^num)-1 and than substitute(test; "9";"aaa") it won't work Dj
  9. I was only kidding, the true formula is Substitute ( (10 ^ num)-1 ; "9" ; textToRep ) If necessary it could be extended for values for "num" greater than 404 Dj
  10. Substitute (Floor ( Exp ( Ln ( 10 ^ num )) ) ; "9" ; "a" ) Dj
  11. Go to desired Layout Print to PDF, blank record showing fields as formated Dj
  12. I didn't have time to reply yesterday, so I was saying the above (the ASCII stuff) because, coincidentally, I have just finished the work on commissioned Sanskrit dictionary ( 57 symbols including diphthongs and triphthongs ) where I was affronting the same question. Globals or related field are out of question because of indexing issue as you surely know. In this moment I can not send you the complete solution (think that my client wouldn't be very happy), but I can assure you that it works like a charm. The substitutive calculation must be indexed or as I said the sort and search could become extremely slow. Also be aware on 63 items in chain limit of Substitute function, so it might be necessary to split the calculation in two fields. (I had to do so because my client asked also to make (ab)use of equivalent characters like e, CustomAlphabet.zip
×
×
  • Create New...

Important Information

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