function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
TilluTillu 

Need percentage for this issue?

I want calculate % of sales  for Sum of Amount/GrandTotal.. But in formulae field i am unable to use Grand Total. I knew we can use ParentVal(row, coloumn) but it displays at Grand total Row/coloumn. I want on all summery levels.


% of sales showing wrong.

User-added image
Ashish_SFDCAshish_SFDC
Hi Tillu,


Do you have this % of sales field on the record? Is it showing the right value there?

How to show percentage of grand total at summary level in reports

http://help.salesforce.com/HTViewSolution?id=000193514&language=en_US

Is it possible to show a Grand Total on a Dashboard?

https://success.salesforce.com/answers?id=90630000000ghEtAAI


Regards,
Ashish
TilluTillu
No % of sales also formulae field in that formulae i want to put  sumOf Amount/GrandTotal * 100   to get percentage
Ashish_SFDCAshish_SFDC
Hi Tillu, 


You can create another field and drag the two fileds in a Matrix report to show the classification and report. 


Regards,
Ashish