Search results for query: *

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

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...

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...

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

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...

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} -...

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...

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...

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

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...

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

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...

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

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

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

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

...1: Sum Invoiced Amount per month Sum 2: Sum Paid Amount per month SolutionGrade Formula: (Sum Paid Amount per month/Sum Invoiced Amount per month)*100 The sums are available in CT, but the solution grade formula is not available so I can put in the solution grade per month. And I cant make a...

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

Not sure what you mean? Best Regards Ernst Noto

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