i need a appformula to calculate every value of a column.
i tryed with:
SUM(
SELECT(
Aba Controle[Mifare Entregue])
)
but i cant.
Solved! Go to Solution.
Try with this:
SUM(SELECT(Aba Controle[Mifare Entregue],ISNOTBLANK([Mifare Entregue])))
Try with this:
SUM(SELECT(Aba Controle[Mifare Entregue],ISNOTBLANK([Mifare Entregue])))
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
i got it!!!
i put the code at app formula:
SUM(SELECT(Aba Controle[Mifare Entregue], and([Data]=today(),[Email]=useremail())
))
and it works
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |