Formula question on dates

[Disiple]

Hey there,

I need to get a count of incidents that have a resolved date greater than the case creation month or week. Hope that makes sense.

Eventually I am going to put it in a chart that would have a row for month created, and then for that month all the cases that were created during it, but resolved after.

Thanks.

 

[lbass]

if {table.resolveddate} >= dateserial(year({table.createddate}),month({table.createddate})+1,1) then
1

Then insert a sum on this at the month group level or use as a summary field in your chart, using sum as the type of summary.

-LB

 

[Disiple]

Not having any luck with the formula. Am I supposed to convert "dateserial" or "month"? Also it changes the type to a detail instead of a measure. Is that correct?

Thanks

 

[lbass]

I have no idea what you mean by:

Also it changes the type to a detail instead of a measure.

You should just be replacing {table.resolveddate} and {table.createddate} with your actual fields.

-LB

 

[Disiple]

ok the formula gives me results, but it looks like it is just giving me the total cases for that month.

What I meant with detail instead of measure was I have three options for the variable type, Dimension, measure, and detail. I thought it should be a measure instead of dimension.

Hope I am making sense.

 

[lbass]

Can you verify that you are using Crystal Reports? Or is "variable type" a field in your database?

What field are you using to create your month group?

-LB

 

[Disiple]

Im using Business Objects XI. I'm assuming then they aren't the same thing, and you cant help? If so, I appreciate the help and apologize for the confusion.

 

[briangriffin]

You're working with a universe - find the person within your company who designed the universe and ask them to incorporate that logic into it.

 

[lbass]

Please try forum393.

-LB