Search results for query: *

I went through this from the beginning again and I am getting the same results, the "Avg" field (@PlaceHolder) is duplicating the count above it instead of averaging. There has to be a factor I am not seeing that is different than what you tested successfully. I have this in the report Footer...

Whoops, 2 of the same image. one of them should be:

Still working on it, but I am still getting unexpected results. I may not be clear on where you are saying "The first formula should be created in the formatting area for the inner row field and the row total, not at the column total level." Moved the Cross Tab to the report footer and added...

Still haven't gotten it to work, but I am betting it is how I am implementing your instructions. Working on it and will update one way or another. I appreciate your help on this!

I think your steps are pretty clear, but maybe I am misreading them. Sorry about the shots but I think it's the best way to step through it with you. Instead of {@0} I created one called PlaceHolder I then went to the first customer count (831) and total (5650) and followed your steps of...

Thanks for the help. Seems more complex than it should have to be, but SAP tends to do that. I did this and as you can see it duplicated the sums of the customer counts instead of averaging, but at least I am a step closer. I attached the screen shot. The one variable I did not mention (not...

I have seen similar questions here, but the answers don't seem to fit my scenario. I am sure it is something relatively easy that I am missing. Using CR2016 I have a cross tab with the days of the week Sunday - Saturday. I have a distinct count of customer IDs for every day and it looks like...

I need to make a similar function like above but using future dates (pre defined). Problem is Crystal has past pre-built functions that I am using now but no corresponding future functions.

Hmmm...no one seems to have a n answer?

I have a function for a parameter for the users to select dates in the past and they rely on the canned functions already in crystal. For instance: If psRunPeriodParameter = "Yesterday" Then CurrentDate - 1 Else If psRunPeriodParameter = "Week To Date" Then...

And that works for each day until the next day. I need to carry over the 2 from the day before to start out the next day. So the report looks something like below. As you can see the 2 left over from Monday are not carrying over to Tuesday so when the 2 still clocked in from Monday clock out...

So scrap the 3 formulas I have? Create a new one called Monday and Set it as If ({Table.DayOfWeek} = 1 ) Then {@InCount} - {@Out Count} Then have a running total formula of just counting the ins and outs for each day and call it RT Tuesday and then add my Monday formula to the Tuesday RT. I...

yes, I am using formulas, but I can't get the running total count to flip to the next day. I think it is because of the day of the week potion of the formula. I have them broken down below. INITIALIZE SUNDAY WhilePrintingRecords; NumberVar RunningTotal_Sun; RunningTotal_Sun := 0; EVALUATE...

You are correct, just can't seem to make that work

I have a report using CR 2011 and it has a column for each day (Monday - Sunday) and does employee counts by the hours of clock ins and clock outs. I have a reset variable for each day but I need to figure out how to rollover counts from Monday to Tuesday. For example on Monday at 10PM I have...

Using SQL Server 2008 I have a pretty long query but the problem I am having is on the left join. I need to left join because there may or may not be a value in there, but when the record has a value I get both records (a value and then a null) and when there is no value I get the single Null...

I am not sure if this is the correct forum, but I do not see any Universe Design forums so if there is a better one to use please let me know. I am using BO 4.0. I built a Universe that is not complex at all, but I do want to have the users use 1 date filter for several date fields and date...

Thanks for the info. Turns out my 1 report maxed out the allowable limit of the Salesforce API calls with 27,000 calls. I am looking into having them do a daily extract to a normal database for reporting. They want to try to keep it open source and on the web, any suggestions?

Here is what is in the show SQL. I let this thing run all day at home and finally got a Failed to retreive data error, exceeds limit. It looks like Salesforce brings everything client side then shows what you want? www.salesforce.com SELECT Cost__c, DP_Profit_Margin__c...

Sure, but it won't be until later this afternoon.