Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

In Report designer What is the best way to add the % Subtotal next to each line

(0) ShareShare
ReportReport
Posted on by 133
Hi,
 
In Report designer i want to add the % of the subtotal  in each line Below is an exemple.
Im not asking about the Variance % between actual and budget, but whithin the actual ,budget or forecast
 
what is the % of sales 1/ Total sales
 
Is it possible?
If so how?
 
Thank you !
 
 
 
 
 
 
 
In my row definitions: I want to add an extra column of calculation exemple, line 2750 i want to add next to the total amount in that account a calculation 2750/3100
 
 
 
 
 
 
 
 
 
 
 
 
 
  • Suggested answer
    Waed Ayyad Profile Picture
    7,847 Super User 2025 Season 1 on at
    In Report designer What is the best way to add the % next to each line
    Hi,
     
    There is a property on Text Box you can set from here:
     
     
    Thanks,
    Waed Ayyad

    If this helped, please mark it as "Verified" for others facing the same issue
     
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    17,296 Super User 2025 Season 1 on at
    In Report designer What is the best way to add the % next to each line
    Hi,
     
    you can set the percentage in text box properties:
     
     
    Best Regards,
    Mohamed Amine MAHMOUDI
     
  • Layan Jwei Profile Picture
    7,722 Super User 2025 Season 1 on at
    In Report designer What is the best way to add the % next to each line
    Hi Community member,

    Do you mean you need the percent to appear in lines marked in yellow? and not just in the final result in subtotal?

    wouldn't adding +"%"  in the expression be enough?​​​​​​​

    Thanks,
    Layan Jweihan

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,020 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans