Im sorry for my english but this works Niko :
LOAD * Inline [
14/10/2013, FL238 ,464, -16
15/10/2013 ,FL238 ,481 ,1
16/10/2013 ,FL238 ,513 ,33
17/10/2013 ,FL238 ,481 ,1
21/10/2013 ,FL238 ,465 ,-15
22/10/2013 ,FL238, 535 ,55
RangeSum(FlexGained,peek(AccumFlexGained)) as AccumFlexGained
DROP TABLE Primero;
Hi Raul and thanks for the quick responce,
I can see that it works on your version but the behaviour on my impementation is not the same.
I use the exact same formula to calculate the running average but insted I get numbers like -6607388,-6607185
and so forth.
I can not figure out why is that....
Can anyone help?? Has anyone had any similar issue??
Here is a sample,
I it took me a minute to hide some sensitive information.
As you can see in the employee number = FL238 i what i am accually trying to achieve is to reset the flex to 480 if its more than that every friday and to keep accumulating from that flex afterwards. I would appreciate your help
flexsample.qvw 1.4 MB