Sum string field

[matisilver88]

Hi, i`m using a spredsheet model to make a report. The model has this fields:

- DeviceName

- Country

- City

- Store (string)

- TImeConnected (int)

I made an object with this hierarchy (for drill): Country - City - Store - DeviceName

Also, i made two card objects, one to showing the sum of TimeConnected field, and other, showing the Sum of Sore field. Here is the problem, I wanna show the store field sum as a number, and when i drill into the object, modify this value, as i could make it work with the TimeConnected field (this was easier because it is an int field, so i show the sum)

How can i make it work?
Thanks in advance!

[PhilipTreacy]

Hi @matisilver88 

Why don't you store the Store values as numbers?

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.