Is there anyway to calculate a column?

[anonymous]

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

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

[LeventK]

Johny_Freitas:

SUM(> SELECT(> Aba Controle[Mifare Entregue])> )

Try with this:

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

[anonymous]

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

[anonymous]

i got it!!!

i put the code at app formula:

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

))

and it works