Hi,
I'm looking to see a custom formula amount on a report for a custom object.
I have the custom formula created and it is showing only at the subtotal/total level.
We have a cumulative capacity number by month and 3 utilities that it will break out between. Each utility has a pre-determined amount and I want to multiply the cumulative monthly capacity by this field (it has a default %, but there is also a picklist of %'s users could override with). Can anyone assist with getting this in each monthly row, not just a grand total?
I've tried to do this by the default amount and also by the field in the formula but all are only showing as a total, not on a monthly view. As you can see in the screenshots below we're just getting a total, not in each row and also the formula to calculate i.e PG&E value.
This should be the cumulative capacity * 0.49 (it is defaulted as 49% and just trying to get the formula to work via this field as opposed to a set number)
Thanks in advance!
Here are the instructions for creating Row Level Formula:
https://help.salesforce.com/s/articleView?id=sf.reports_formulas_row_level_add.htm&type=5
Let me know if this works.