function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mr. WMr. W 

Report: Formula Help

A matrix report gets me 90% to where i need to be but I need to add a formula subtracking the two columns.  

 

I have a custom object "Financals." with three fields

  • Group
  • Period:  (2011, 2012.... ect.) 
  • Revenue (currency)

The report just needs three columns  and will be (grouped by the "group" field) 

 

column 1:  Peroid 2011 (totals Revenue)

column 2: Peroid 2012 (totals Revenue)

column 3:  Variance (Column 2 - Column 1)

 

Thanks!  

sivaextsivaext

Hi 

 

you  can create matrix report and group year.

 

you can't create formula to calculate each row.
sivaextsivaext

hi

 

you can't formula on getting value on each row. To achive this requirment , need to create formula field at object level.