topic Re: Previous most recent non-zero value in App Development

Previous most recent non-zero value

callmedaddy — Fri, 14 May 2021 16:36:02 GMT

Hello,

I'm trying to set the values of all the months indicating 0 with the previous most recent non-zero value.

For exemple, I have the following:

Jan 1042

Feb 0

Mar 12

Apr 0

May 0

And I want to achieve this:

Jan 1042

Feb 1042

Mar 12

Apr 12

May 12

I want to do this in script. Any solution?

Thanks!

Gysbert_Wassenaar — Fri, 14 May 2021 16:48:29 GMT

Something like this:

load *, If(Value = 0, Peek(NonZeroValue),Value) as NonZeroValue inline [
Month, Value
Jan, 1042
Feb, 0
Mar, 12
Apr, 0
May, 0
];

callmedaddy — Fri, 14 May 2021 16:59:29 GMT

Works perfectly! Thank you, @Gysbert_Wassenaar !