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...
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...
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...
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
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.