You need to sign in to do that
Don't have an account?

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!
Hi
you can create matrix report and group year.
you can't create formula to calculate each row.
hi
you can't formula on getting value on each row. To achive this requirment , need to create formula field at object level.