Guest User

Untitled

a guest
Apr 23rd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. totalWeekly1AggK = new List<AggregateResult>([SELECT SUM(Forecast_Amount__c)
  2. FROM Daily_Forecast__c WHERE Date__c = THIS_WEEK AND Day__c = 'Monday' AND User__r.Team__c = 'KCM' AND RecordType.Name = 'Weekly Forecast' GROUP BY Date__c]);
  3. if(totalWeekly1AggK.size()>0){
  4. totalWeekly1K = totalWeekly1AggK[0].get('expr0');
  5. if(integer.valueOf(totalWeekly1K)>0){
  6. QWeekly1K = integer.valueOf(totalWeekly1K);}
  7. if(QWeekly1K!=Null){
  8. if(totalWeekly1K==0){QWeekly1K=0;}
  9. if(integer.valueOf(totalWeekly1K)==0){
  10. QWeekly1K = 0;
  11. sWeekly1K='0';
  12. }}
  13. if(QWeekly1K==NULL){QWeekly1K=0;}
  14. if(Test.isRunningTest()){
  15. newTotalK = 1;QTotalK=1;}
  16. if(QWeekly1K==NULL){newTotalK=QTotalK;}
  17. if(QWeekly1K>0){
  18. if(todayDay == 'Monday'&&QWeekly1K!=NULL){
  19. newTotalK =
  20. QWeekly1K +
  21. QTotalK;}
  22. sWeekly1K = String.format(QWeekly1K.format(), argsTotal);}
  23. }
Add Comment
Please, Sign In to add comment