Solved: Lead Tracking app - how to sum the lead values? - Page 2

luuthieuky · 11-06-2022 10:23 PM

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

gregdiana1

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