• Billy Jacobs 11
  • NEWBIE
  • 0 Points
  • Member since 2021

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

Here is my query......

q = load "Plan_Number_MS";
q = group q by all;
q = foreach q generate sum('Plan') as 'sum_Plan';
q = limit q 2000;
p = load "Oppotunity_Inc_Martketing_Info";
p = filter p by 'ForecastCategory' in ["Closed", "Forecast"];
p = group p by all;
p = foreach p generate sum('ACV__c') as 'sum_ACV__c';
p = limit p 2000;
s = union p,q;
t = group s by all;
t = foreach t generate sum('sum_ACV__c') as 'thesumO' , sum('sum_Plan') as 'thesumP';
u = foreach t generate round((thesumP-thesumO),0) as 'Gap to Plan';

It is returning the right figure, but I need to format it as $1,234,567.......how do I do this please?

Thanks in advance

Emma