ShowAll Questionssorted byDate Posted
George 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?

Best Answer chosen by George Laird 39
Maharajan C
Got it George...

update the formula custom sumary formula like below:

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

Classic  Report Screenshot:

Lightning Report Screenshot:

And Final Ouput will be like below:

Thanks,
Maharajan.C

Maharajan C
Hi George,

You have to create the custom summary formula in report:

2. Drag the add formula from pallete in report

3. Edit the formula:

Fomula:  Payment:SUM    -   Refund:SUM

Create the formula using the Summary fields Option.

refer the below screen shot for choosing summary fields.

4. Click the OK button.

Thanks,
Maharajan.C
George 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 C
Got it George...

update the formula custom sumary formula like below:

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

Classic  Report Screenshot:

Lightning Report Screenshot:

And Final Ouput will be like below:

Thanks,
Maharajan.C

This was selected as the best answer
George 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 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 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 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 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".