How to remove decimal values from cellular data

General
1

Currently cellular data shows decimal values, is there a way to remove decimal values?

2

You can use a workaround like this

$tc(split, ts(mt, a, 1dr1M, 1dr1d), ",", 0)$$tc(cut, ts(mt, a, 1dr1M, 1dr1d), -2)$

The first formula are going to print the first part of the code prior to the coma.

The second part are going to print the last two letters of the code.

3

Thank you for your response, however I could not get this to work.

Currently I have $ts(mt, a, 2d)$ and my result is 1.54mb. It would be good to have this rounded up to 2mb or at least just show 1mb.

4

You need to use the entire formula if not this don't work.

$tc(split, ts(mt, a, 2d), ",", 0)$$tc(cut, ts(mt, a, 2d), -2)$

5

I have tried it, I get a result of 1.58mbmb

6

$tc(split, ts(mt, a, 2d), ".", 0)$$tc(cut, ts(mt, a, 2d), -2)$

try this with a point instead the coma

7

Thank you

This one worked perfectly.

$tc(split, ts(mt, a, 2d), ".", 0)$$tc(cut, ts(mt, a, 2d), -2)$

8

you are welcome!👍😃

9

Actually the formula worked with $tc(split, ts(mt, a, 2d), ".", 0)$

10

Yes the first formula is for the numbers, the second is for the type of numbers, kb, mb or gb. If you change the

a, 2d

for

a, 1d

you have the data from the first day of the month.👍