Hi there, apoligies, if this is easy to solve, but I am new to Targit.

I work with data series, that have different frequency. Some data is with minute resulution, some hourly.

The dataset looks like this, when presented:
( strange, the BBCODE monospace is not supported, apoligies, but using underscore to make tables)

_____1minvalue___5minvalue
1_____3_____________22
2_____3_____________
3_____4_____________
4_____3_____________
5_____5_____________
6_____3_____________100
7_____3_____________

Unfortunately, the blank data is interpreted as 0 not NULL, so what is read by targit is


_____1minvalue___5minvalue
1_____3_____________22
2_____3_____________0
3_____4_____________0
4_____3_____________0
5_____5_____________0
6_____3_____________100
7_____3_____________0

Needless to say, the graph is not pretty - the 5min value is 22 for the entire time period, so what really should be read is

_____1minvalue___5minvalue
1_____3_____________22
2_____3_____________22
3_____4_____________22
4_____3_____________22
5_____5_____________22
6_____3_____________100
7_____3_____________100

Thanks to the good video on syntax, I could quickly do a custom formula to fix the data:

if sum(d-3, 0, m1) = 0 then sum(0, -1, m1) else sum(d-3, 0, m1)

Unfortunately, the result is not entirely recursive:


_____1minvalue___5minvalue___my formula
1_____3_____________22_____22
2_____3_____________0______22
3_____4_____________0______0
4_____3_____________0______0
5_____5_____________0______0
6_____3_____________100____100
7_____3_____________0______100

So the formula is working, I pick the value above the present cell, if the column I am looking into is zero, but only once, not every time. It appears, that the formula does not recognize the calculated field above. I tried using c1 instead of 0 as column, but that was not working

So either I need to find out how how to handle NULL as previous value, or something like the above.

I see in the forum that I am not the only one with this issue, but others try to hide NULL data, I try to overwrite it.

NULL problems!

Thanks in advance

Henrik

How strange. The exact formula I posted here is working fine now.. Anyway, now it's there for anyone with the same problem

Thanks for testing though

BR

Henrik