Search results for query: *

Worked Perfectly!! As always... Thank you

I am wanting to group by a formula that will give me all the open items between 7 and 14 days and then another group for 14 - 21 and so on, so I cannot use the select expert. I am using the formula below, which gives me "true" or "false" and shows all the entries grouped by true or false as...

This works perfectly!!! You're the best and thanks much.

Formula function: I am working with a manual crosstab. I need a formula to say, "if date = Monday", show me a distinct count of "x" just for Monday. I have various selections taking place so I'm unable to use //{@Monday}: if dayofweek({Date}) = 2 then 1. I need to take that day of Monday and...

lbass - Thank you very much. This works perfectly and helps me so much!!!!

Reports function: Manual crosstab for Support Center to calculate how many calls come per office during any given week. Rows show the Office Name, Column heading is day of week, mon, tues, wed... result is the count of tickets per day, for that office. I'm always just doing Mon-Fri. Parameter...