function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
George Laird 39George Laird 39 

report formula help

Can someone help me with a report formula?  How can I get a net of the PAYMENT - REFUND for each payment type?   



User-added image
Best Answer chosen by George Laird 39
Maharajan CMaharajan C
Got it George...

update the formula custom sumary formula like below: 

Formula:  PREVGROUPVAL(Total:SUM, TYPE)  - Total:SUM

Classic  Report Screenshot:

User-added image


Lightning Report Screenshot:

User-added image

User-added image


And Final Ouput will be like below:

User-added image


Thanks,
Maharajan.C


 

All Answers

Maharajan CMaharajan C
Hi George,

You have to create the custom summary formula in report:

Please follow the below steps:


1. Customize your report:

2. Drag the add formula from pallete in report 

User-added image

3. Edit the formula:

Fomula:  Payment:SUM    -   Refund:SUM

Create the formula using the Summary fields Option.

User-added image

refer the below screen shot for choosing summary fields.

User-added image


4. Click the OK button.

Thanks,
Maharajan.C
George Laird 39George Laird 39
@Maharajan.C, thanks so much, but I'm not sure that's working.  Payment and Refund are both values  of the field "type".  There are two groupings on this matrix:  Type (x axis) and Payment Type (y axis.)   I'm trying to say "take the field "total" for when the TYPE is "payment" and subtract the "total" for when the TYPE is "refund."  
Maharajan CMaharajan C
Got it George...

update the formula custom sumary formula like below: 

Formula:  PREVGROUPVAL(Total:SUM, TYPE)  - Total:SUM

Classic  Report Screenshot:

User-added image


Lightning Report Screenshot:

User-added image

User-added image


And Final Ouput will be like below:

User-added image


Thanks,
Maharajan.C


 
This was selected as the best answer
George Laird 39George Laird 39
@Maharajan.C  Thank you, that works, however, is there a way to get the total as a new column rather than have it be in the second box?  In your example above, you have a column for "Existing Customer - Upgrade" and then "New Customer".  Is there a way to have a new column right after that has that total?

 
naman mathur 10naman mathur 10
Thank you, that works, however, is there a way to get the total as a new column rather than have it be in the second box?  In your example above, you have a column for "Existing Customer - Upgrade" and then "New Customer".  Is there a way to have a new column right after that has that total? trmodz tk (https://www.trmodztk.xyz/)
Alex Hall 16Alex Hall 16
The marketplace is crowded with all types of custom app development company (https://www.skypotential.co.uk/services/mobile-app-development). Today, even businesses who never would’ve needed apps in the past are getting into the game.
anthony masonanthony mason
Much obliged to you, that works, in any case, is there an approach to get the all-out as another segment instead of having it be in the subsequent box? In your model above, you have a section for "Existing Customer - Upgrade" and afterward "New Customer". Is there an approach to have another section just after that has that all out? According to my mind, I can give the best suggestions about homework help UK (https://www.assignmentace.co.uk/homework-writing-service/),  but I'm also responsible for the app development websites where I can carry all the work. 
mandy angelicamandy angelica
I think Thank you, that works, however, is there a way to get the entire as a new column as opposed to having or not it's inside the second box?  In your example above, you've http://thedissertationhelp.co.uk/research-paper-writing-service/ got a column for "Existing Customer - Upgrade" after which "New Customer".
mygodimages commygodimages com


Thanks For Sharing This Post Hey Guys If You Want To Download Happy New Year 2021 Images Photo Then Visit This Link And Download Happy New Year 2021 Images Photo Free Happy New Year 2021 Images Photo (http://  https://myimgstock.com/c/happy-new-year-images-photo-2021)
Monika Jacob 9Monika Jacob 9
Have you learned any lessons from mistakes made in previous assignments? If your assignments are still bothering you, I suggest you go to Research Paper Writing Service (https://www.theacademicpapers.co.uk/research-paper-writing-help.php) which is the best writing help provider agency. 
Malik WaqasMalik Waqas
All the amazing features of Pirlo TV APK are art and unique compared to other types available now. Pirlo TV v1.5 Apk Lover's Si vous souhaitez télécharge 
https://apkfinds.com/pirlo-tv
Ruth BeaudinRuth Beaudin
There are two groupings on this matrix:  Type (x axis) and Payment Type (y axis.)   I'm trying to say "take the field "total" for when the TYPE is "payment" and subtract the "total" for when the TYPE is "refund."  app design price (https://spdload.com/blog/the-cost-of-app-design/) depends at the design rates, location, in addition to the extent of complexity and customization of the layout.
Titanium tv apkTitanium tv apk
Thank you for your post, I look for such article along time, today i find it finally. this post give me lots of advise it is very useful for me. Do you know about Titanium tv apk. Titanium TV APK (https://titaniumtv-apk.com) is the great source of enjoying movies and daily soap without any cost. 
hen dizhen diz
Instagram è la piattaforma perfetta per coloro che sono interessati a mostrare le foto e le immagini che creano. Se sai come vedere chi visualizza il tuo profilo instagram o legge le tue storie, scopri come farlo. https://migliorguida.net/come-vedere-chi-visita-il-tuo-profilo-instagram/
Jonathan PryceJonathan Pryce
Be sure you are working with a reliable software development partner. Here's a nice guide on how to choose a software development company - https://www.cleveroad.com/blog/how-to-choose-a-software-development-company
Ava James 3Ava James 3
If you're having trouble with your reports, our formula help section is here to help! Our experts have put together a comprehensive guide that covers everything from the basics to more advanced concepts. Check out this https://www.theassignmenthelp.co.nz/apa-reference-generator/ (https://www.theassignmenthelp.co.nz/apa-reference-generator/" target="_blank). It's a great tool that can help you create citations quickly and easily.
Betty mills 10Betty mills 10
Are you aware of the requirements for acing your assignment? In addition to the prerequisite
knowledge of the subject, there are numerous more conditions. best assignment writing service  (https://royalbritishessaywriters.co.uk/) It is a time-consuming and difficult
process, which is why many students ask us to write their assignments. Even for last-minute writing
assignments, we provide a dependable assignment writing service that guarantees passing scores. Since
each academic assignment has specific standards and guidelines that must be taken into account. Some
call for in-depth subject investigation, while others call for case study resolution.
Marsha KaplanMarsha Kaplan
Your formula helps me alot and thanks to you because you have resolved my issue as I need to perform the same formula but I did not know the rules of formula. I have also taken assistance from a reputable company of UK https://www.assignmentuk.co.uk/ but your assistance is really simple and effective.