function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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)






you  can create matrix report and group year.


you can't create formula to calculate each row.




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