Is there anyway to calculate a column?

i need a appformula to calculate every value of a column.
i tryed with:

SUM(
SELECT(
Aba Controle[Mifare Entregue])
)
but i cant.

image

Try with this:

SUM(SELECT(Aba Controle[Mifare Entregue],ISNOTBLANK([Mifare Entregue])))
1 Like

Its work greats, TKS.

But now i need to Sum only values that column Email is equal useremail() and Column Data is equal today().

because thinking i’m useremail() "johny.freitas@teste.com"
i need to see how much Mifare Entregue i delivered today
i don’t need to know about the other’s.

i put this app formula in slice but not work:

And([data]=today(),[Email]=useremail()

and still sum every value from column

image

i got it!!!

i put the code at app formula:

SUM(SELECT(Aba Controle[Mifare Entregue], and([Data]=today(),[Email]=useremail())

))

and it works

2 Likes