Does anyone know how to bind the xml attribute to a Salesforce field. For some reason all the records that are being created are null. I am trying to get the player name and id.
I'm trying to create a custome report via Visualforce. I have a custom object called Quota's. For each month I'm trying to sum all the closed opp amount values per a particular user and divide it by the users quota for that month.
EX: Jims Quota for January is $10,000. He has Closed $20,000. So his % is 200% for January. I'm geting all the values correct but it shows 200% for everyone in the Jan column. I've tried converting values into a string and storing them in a list but i can't seem to get it working properly. I've attached the code on the bottom. Any help is greatly appreciated.
-Hersh
Class:
public class QuotaReport { public User[] SalesRep {get; set;} public Opportunity[] OppList {get; set;} public Quota_Custom__c[] Quota {get; set;} public decimal Jan {get; set;} public decimal Feb {get; set;} public decimal Mar {get; set;} public decimal Apr {get; set;} public decimal May {get; set;} public decimal Jun {get; set;} public decimal Jul {get; set;} public decimal Aug {get; set;} public decimal Sept {get; set;} public decimal Oct {get; set;} public decimal Nov {get; set;} public decimal Dec {get; set;} public String CurrYear = String.valueOf(Date.today().year()); Public Date Jan1 = Date.valueOf(CurrYear+'-01-01'); Public Date Jan31 = Date.valueOf(CurrYear+'-01-31'); Public Date Feb1 = Date.valueOf(CurrYear+'-02-01'); Public Date Feb28 = Date.valueOf(CurrYear+'-02-28'); Public Date Mar1 = Date.valueOf(CurrYear+'-03-01'); Public Date Mar31 = Date.valueOf(CurrYear+'-03-31'); Public Date Apr1 = Date.valueOf(CurrYear+'-04-01'); Public Date Apr30 = Date.valueOf(CurrYear+'-04-30'); Public Date May1 = Date.valueOf(CurrYear+'-05-01'); Public Date May31 = Date.valueOf(CurrYear+'-05-31'); Public Date Jun1 = Date.valueOf(CurrYear+'-06-01'); Public Date Jun30 = Date.valueOf(CurrYear+'-06-30'); Public Date Jul1 = Date.valueOf(CurrYear+'-07-01'); Public Date Jul31 = Date.valueOf(CurrYear+'-07-31'); Public Date Aug1 = Date.valueOf(CurrYear+'-08-01'); Public Date Aug31 = Date.valueOf(CurrYear+'-08-31'); Public Date Sept1 = Date.valueOf(CurrYear+'-09-01'); Public Date Sept30 = Date.valueOf(CurrYear+'-09-30'); Public Date Oct1 = Date.valueOf(CurrYear+'-10-01'); Public Date Oct31 = Date.valueOf(CurrYear+'-10-31'); Public Date Nov1 = Date.valueOf(CurrYear+'-11-01'); Public Date Nov30 = Date.valueOf(CurrYear+'-11-30'); Public Date Dec1 = Date.valueOf(CurrYear+'-12-01'); Public Date Dec31 = Date.valueOf(CurrYear+'-12-31'); public QuotaReport(){ SalesRep = [Select Id, Name, ProfileId FROM User];
Quota = [Select Id, Name, January__c, February__c, March__c, April__c, May__c, June__c, July__c, August__c, September__c, October__c, November__c, December__c, Year__c, Salesperson__c, Salesperson__r.Name FROM Quota_Custom__c WHERE Year__c=:CurrYear AND Salesperson__c=:Salesrep];
