0

I have a chart showing following information but now i need to have instead of numbers the percentage. Now it shows percentage of all records. But im interested if its possible to count % separately for A, and separately for B and D. How should i write formula? I'm vey new with SF

enter image description here

enter image description here

Improve this question
7
  • Welcome to SSE ! Do you want the % of count ?
    – SaiPraveen Kakkirala
    Commented Dec 21, 2022 at 11:10
  • @SaiPraveenKakkirala yes, exactly
    – KseF
    Commented Dec 21, 2022 at 11:43
  • @SaiPraveenKakkirala your advice is very good. I have updated my question, can you have a look if the formula can be improved to show % for A, B and D I mean if we look at A, then it has 133 records and its around 60%
    – KseF
    Commented Dec 21, 2022 at 12:25
  • Do you want percentage calculation different. Are these on same report? or have to added them as matrix of reports?
    – SaiPraveen Kakkirala
    Commented Dec 21, 2022 at 12:30
  • @SaiPraveenKakkirala yes, i want % be calculated differently. I wandering if its possible to calculate 100% of records for A (B and D) separately. Like total record for A is 190 Then -133 is around 70% A 12 is around 5% B 23 is around 12% C 5 is around 3% D 19 is around
    – KseF
    Commented Dec 21, 2022 at 12:46

2 Answers 2

Reset to default
2

You can create a formula field in the report to show the percentage. The formula should be as below.

 (RowCount / PARENTGROUPVAL(RowCount, GRAND_SUMMARY)) *100

enter image description here

Please find the article for the same

Improve this answer
0

solution: RowCount / PARENTGROUPVAL(RowCount, here i wrote the field name)

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .