Lead Tracking app - how to sum the lead values?

[luuthieuky]

I want to summarize the values of all the leads but right now the available app on Appsheet only count the number of leads. 

Can anyone help me out with the detail code / action to do? 

Many thanks 

[Hussein_Osseily]

i have worked on something like that but different type of data, if you may share more specified details i might be able to help you.

[gregdiana1 · Accepted solution]

Hi,

In order to count the number of leads you first have to obtain the list of leads like

COUNT(SELECT(Customers[Leads], TRUE, TRUE))  this is of TYPE number

If you do

SELECT(Customer[Leads], TRUE, TRUE) it will return the list of all leads but must be of type LIST and not number.

Just use a virtual column of TYPE list