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
Vladimir BessonovVladimir Bessonov 

how to sum all values in column picklist value is equil to some value

Hi. I am writing a report on a custom object. 
I have an issue with creating the report 

mu records have quantity and status 
I want to get a summary of each record in different statuses. 
How it can be done? 

report on custom object
SUCHARITA MONDALSUCHARITA MONDAL

Hi Valdimir,

You can use 'GROUP BY' option on status field. Also by going on Columns--> Choose Quantity filed--> Click on Quantity Field and  Click on "Sum".

Hope this helps!

Thanks,
Sucharita
Vladimir BessonovVladimir Bessonov
The question was how to calculate quanity based on status
Status can be SENT, ARRIVED, ACCEPTED. 
I need TOTAL SENT Quantity, TOTAL ARRIVED Qunaitym TOTAL ACCEPTED Quantity. 
your answer doesnt help at all. 
kamala swarnalathakamala swarnalatha
Hi,

A summary of the picklist value is not possible in the report.

If you need the record count for each status just group the report by the status field and then see the record count of each value.

User-added image

Or If you need the total record which has picklist values please follow the below link to get the sum of the total record.

https://trailblazers.salesforce.com/answers?id=9063A000000l8vlQAA

Please explain your requirement briefly to understand further. Hope it helps.

Let us know if you have further questions.

Thanks,
Kamala. K
Sweet Potato Tec