• JElliot
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Hello all,

I am trying to build a report for a manager of multiple teams where I can show what percent of the monthly goal each team is at for activities.  Unfortunately the teams do not have the same number of users in each of the roles below.  Some have 7 and others have 8.  Is there a way to use a formula to go something like this (bold appears to be the field I am not getting correct:

RowCount / (250 * (IF ("Assigned Role" = "ABC:BCD" , 7, 8 )))

Where ABC and BCD roles return a value of 7 and all other roles return 8.  Anyone have any ideas if this can be done?  Or am I simply better off doing individual reports for each Role and thus removing the need to use the role in the formula.

A second question, would there be a way to calculate the number of business days in a month?  We are Mon-Fri and say each person needs to enter 25 activities a day, could a formula be used to differentiate between months with less working days?  For instance Feb has 20 working days but March has 23.
I have downloaded a Blackberry Mobile simulator (version: 8130-Verizon) from the Blackberry site and installed it in my machine. I have configured Blackberry MDS simulator to work behind a proxy. It is working fine. I have installed the Salesforce Mobile Application.
But after that whenever I am trying to configure the Salesforce Mobile application, I am getting struck in the screen showing: "Device info has been sent to salesforce.com and is awating registration".
 It is not proceeding any further. Any help?

thanks,
srijan