Search results for query: *

You can also concatenate the start dates and end dates with cdate function to convert to date then subtract based on what datediff you want.

i have a cross tab report that i want to add the month using formula. If month = january, add all january cost, if month is feb, january cost+febraury cost. if month is march then january+feb+march cost and so on. any help will be appreciated.

I have this report i'm having issue with crystal 2011. It is a cross tab that is made up of column months and summary fields from formulas that sums up the cost for financial years. first row is FY14 second row is FY15 and third row is FY16 all these from formulas. then the next row is supposed...

I'm not sure I understand you well but since you know your formula to use, the condition you want to use in the record section should be used in the formula section and use the formula instead of the field.

Thank you ken

where will this formula be created, in the format text on the crosstab or as a separate formula?

It true crystal report crosstab. It is a replica of an excel report. The 1's and 0's are formula field. How I did it is, I didn't add any field to the rows field in the cross tab then then the grid lines to that section and text, I used background color to hide them and then used text object to...

Unable use formula because the formula fields are based of sum of 1's and 0's and these are to be for different months. when I use formula, it returns same value for all months.

This is a screen shot from the report. I can not use formula to achieve this because the figures up there are sum of 1's and 0's and when I use this formula, (sum({@frmCMcount})/sum({@frmtotalSCCMcomp}))*100 it returns a single value for all the...

No how I'm doing it is I add the field to the summarized section under the crosstab expert and then select change summary. Then I select weighted average with then the field and ok

Thank you Skip. I tried doing that but where do I multiply the value. I tried multiplying under the format customization and decimals

I have a crosstab that returns weighted average value as .45 but I want it displayed as 45. How can I achieve this?

can you try something like this? I haven't tried it though if isnull({field}) then previous({field}) else {field}

Thanks so much Brian. It works great

i have a column that has two values 1 and 0. these have been grouped and I want to suppress the detail of the group that has only 0s and show those that have both 1 and 0. any help?