calculated values

[#1]

Dear All,

I'm new and I woluld like to have calculated values as diff from meter counter ,

date	meter counter	diff
2017-04-04 01:00	22628
2017-04-04 02:00	22629,7	1,7
2017-04-04 03:00	22631,4	1,7
2017-04-04 04:00	22633,1	1,7
2017-04-04 05:00	22634,9	1,8
2017-04-04 06:00	22636,6	1,7
2017-04-04 07:00	22638,3	1,7
2017-04-04 08:00	22640	1,7

How can obtain this ?

[beck_bakytbek]

Hi Zelazek,

can you give a screenshot of example? what kind of output do you expect?

[vishsaggi]

Try this:

Table1:

LOAD * INLINE [

date, metercounter

2017-04-04 01:00, 22628

2017-04-04 02:00, 22629.7

2017-04-04 03:00, 22631.4

2017-04-04 04:00, 22633.1

2017-04-04 05:00, 22634.9

2017-04-04 06:00, 22636.6

2017-04-04 07:00, 22638.3

2017-04-04 08:00, 22640

];

NoConcatenate

LOAD date,

     metercounter,

     IF(metercounter - Previous(metercounter) = '', '', metercounter - Previous(metercounter)) AS Diff

Resident

Table1;

Drop Table Table1;

Using Straight table :

Dim:

date

metercounter

Expr:

diff

[beck_bakytbek]

Check this: https://www.youtube.com/watch?v=WwoCepEYrsQ

[Anil_Babu_Samineni]

One Front-End Solution May be this?

Change the Environment ThousandSep from Comma(,) to Dot(.)

Then Try this?

Num(Sum([meter counter]) - Above([meter counter],1),'#,##0.0')

Or Simple do this without change any thing

Replace(Num(Sum(Replace([meter counter],',','.')) - Above(Replace([meter counter],',','.'),1),'#,##0.0'),'.',',')