Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ErnstNoto

    Week number and Leap Year

    Hi all! thank you all for youre replies. Skip: You are correct, when using the formula corrctly, it will Return week 53. Not sure what I have been doing wrong. Works as expected now. Best Regards Ernst Noto
  2. ErnstNoto

    Week number and Leap Year

    The problem is that the datepart formula wont give me week nbr 53. When using the datepart formula above, Crystal will not make week nr 53, the year still ends in week nbr 52. And the first week of 2016 is stated as week nbr 2. I Guess the problem really is that week 53 exists both in 2015 and...
  3. ErnstNoto

    Week number and Leap Year

    Hi! I've had some reports the last couple of years where I report on week numbers. This has been working just fine up until now. 2016 It is a Leap year and 2015 had 53 weeks is. The formula I've used in Crystal wont identify this: DATEPART("ww",{@Regdato}, crmonday) Anyone who has an idea on...
  4. ErnstNoto

    Timeline - created and update date

    That is exactly what the problem is. I have thought of subreports, but the problem there is that, as far as I know, I can only send total sums to a sub report and not Group sums to Place inn a table. Best Regards Ernst Noto
  5. ErnstNoto

    Timeline - created and update date

    Hi I have a data table which for example have the following fields. Id; Reg.date; Duedate; User ID; Case nbr; Update date 746056; 2015-02-10; 2015-03-12; IMA; E28896; 2015-03-13 746060; 2015-02-11; 2010-02-08; DK; C55411; 2015-03-13 746066; 2015-02-17...
  6. ErnstNoto

    Solvent Ratio

    yes I placed formula 1 in a seapare Group footer (GF2b). I have however been moving it around to se the effects, and formula 1 (SHARED NUMBERVAR PREVTOT:= {#02 Dir Paid Mth}) gives the same result in both Group footers (GF2A&GF2B). Formula 2 (SHARED NUMBERVAR PREVTOT; {#02 Dir Paid Mth} -...
  7. ErnstNoto

    Solvent Ratio

    Hi! Feeling a bit dumb here now cause I dont get it? I have f.ex these numbers using a running total on a formula called {@02 Dir Paid} Jan - {#02 Dir Paid Mth} = 660 148 Feb - {#02 Dir Paid Mth} = 0 Mar - {#02 Dir Paid Mth} = 3 654 927 Apr - {#02 Dir Paid Mth} = 61 137 May - {#02 Dir Paid...
  8. ErnstNoto

    Solvent Ratio

    Thank you! I might have done something wrong but as I explained above I have already tried this and it dont work. When using a running total for month 1 in the formula for month 2, it still resets. It comes out as zero in formula for month 2. I'll try again in case I have done something wrong...
  9. ErnstNoto

    Solvent Ratio

    a type error in one of my examples - accumulated solvent is in month 2 offcourse 50% (not 30) :-) Best Regards Ernst Noto
  10. ErnstNoto

    Solvent Ratio

    Hi I have a solvent ratio report that sees every month separetly Nbr of delivered invoices each month Amount paid on these etc…. Presented like this: 2013 Month - Nbr_Inv - Recevied_Pricipal - Current_Pricipal - Paid_Principal - SolventRatio Janury - 428 - 500 - 200...
  11. ErnstNoto

    Splitting a field based on a delimiter

    Thanks!:-) That was not to hard :-) Best Regards Ernst Best Regards Ernst Noto
  12. ErnstNoto

    Splitting a field based on a delimiter

    I have a description field in my database which I would like to split into two separate Fields in my report. The information is always separated with a colon. I cant use the left/right function because the positions change. The field contains information on a merchant on the rigt side, and the...
  13. ErnstNoto

    Vertical Grouping

    Again, Thank you. :-) Best Regards Ernst Noto
  14. ErnstNoto

    Vertical Grouping

    Not sure if I fully understand what I am doing, but it works - Thank you so much! :-) Best Regards Ernst Noto Best Regards Ernst Noto
  15. ErnstNoto

    Vertical Grouping

    Tank you, I have been trying to locate a thread, but I still haven't found any. Also, the CR version I have is 11.5.12.1838 I will keep looking, but if you by chance should have a thread number/link, that would be greatly appreciated. Best Regards Ernst Best Regards Ernst Noto
  16. ErnstNoto

    Vertical Grouping

    I know, but as long as I cant choose to show it as percentage of other than itself, it is not really interesting. I want one of the sums to be shown as percetage og another sum, and I cant figure out how in CT Best Regards Ernst Noto
  17. ErnstNoto

    Vertical Grouping

    It is not that I want to summarize a field later. The sums are available in CT, but I need the sums for each month to calculate a soulution grade. This in itself is not a complicated thing. The report is grouped by year and month. And I wish to present this horisontally, and CT offers this. But...
  18. ErnstNoto

    Vertical Grouping

    Not sure if i did it correctly, but my effort resultet in the following error: "A print time formula that modifies variables is used in a chart or map" Best Regards Ernst Noto
  19. ErnstNoto

    Vertical Grouping

    Not sure what you mean? Best Regards Ernst Noto
  20. ErnstNoto

    Vertical Grouping

    One problem with cross tab - San only present sumarized fields. I have formuals within a group that calculates results out of certain sums. Doesnt seem to be possible to insert a formula like this Best Regards Ernst Noto

Part and Inventory Search

Back
Top