Skip to main content
Samantha Miller ha fatto una domanda in #Reports & Dashboards

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)

Showing row level amount with custom formula

 

Screenshot 2024-02-28 at 12.44.19 PM.png

 

Thanks in advance! 

 

#Reports & Dashboards  #Formulas  #Formula Help  #Reports

8 risposte
0/9000