add 2 Row-Level Formula - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
John SebastinJohn Sebastin 

add 2 Row-Level Formula

Can we Add 2 Row-Level Formula's in Salesforce report.
Row-Level Formula
Mira ShahMira Shah
Hello John,
Please see below help article. 
Get the Most Out of Row-Level Formulas: Tips, Limits, and Limitations
https://help.salesforce.com/articleView?id=sf.reports_formulas_row_level_limits.htm&type=5

Vote below Idea. 
Increase limit of row level formula in report
https://trailblazer.salesforce.com/ideaView?id=0873A0000015AAiQAM
Steve MolisSteve Molis
No, that's not possible right now, 1 is the limit.  

What is the Formula you're trying to build?  Would it be feasible to create a Formula Field instead?
Mira ShahMira Shah
Please put best answer, if you have solved the issue. 
John SebastinJohn Sebastin
I am trying to create "weighted average" whcih should be able to reflect in the dashboard.

Please find my below screen shot that explains my Adjusted TCV and weighted average formula.

Can you help me create formaul to calcuate "weighted average"

Weighted Average
Steve MolisSteve Molis
How are you getting 30 in cell E2?  

( $63,000 x 0.05 ) = $3,150 
John SebastinJohn Sebastin

Data in column E is constant

I am able to create Row level formula for Adjusted TCV but i am not able to create "Weighted Average" that is in cell D14.

My question is how do i create Weighted Average (refer formual in cell D14)

 

Steve MolisSteve Molis
Have you tried creating a Formula Field on the object like I suggested?
John SebastinJohn Sebastin
i tried - but i was not successfull.

can you help me with Excel alternative formual that works good in salesforce (refer formual in cell D14)
Steve MolisSteve Molis
Where is that number coming from?  Is it just a Number field on the Opportunity object? 

What does the 30 in cell E2 represent? 
John SebastinJohn Sebastin
Yes it is a Number field on the Opportunity object
it is an field on Opportunity object and the value is captured from that field
Steve MolisSteve Molis
Have you tried doing this in a Formula Field on the Opportunity object?
John SebastinJohn Sebastin
yes i did but was not successful.
Can you get me that formaul
Steve MolisSteve Molis
Can you post the formula that you used and a screenshot of the results you got?
John SebastinJohn Sebastin
Steve prefer to have call. Can we get into a call to discuss on this.
Steve MolisSteve Molis
Can't right now, I'm on vacation. Excuse the brevity I'm on my mobile phone
John SebastinJohn Sebastin
Ok waiting to connect on webex after your vacation
John SebastinJohn Sebastin
Hi Hope you are back after your vacation
Steve MolisSteve Molis
Hi John, I'm back, but I am also swamped.  Not sure if I'll be able to duck out of work for a WebEx call today
John SebastinJohn Sebastin
No issues can we connect tomorrow