Challenge #381: Average Monthly Sales with a Twist

[natalierosehouse]

3 solutions to this one! the third could be converted to IN-DB tools if needed on large datasets

[Amy_smart]

Here is my solution. 

[lwolfie]

Nice challenge

[cmoussa]

[Bennu]

Used an interesting artifice to reach the solution faster.. check it out!

Spoiler

if [Row-1:sum3conseq] >30000 then
[Row-1:sum3conseq]

elseif [Row-1:sum3conseq] >20000 then
[Row-1:sum3conseq] + 10000 + tonumber([value])

elseif [Row-1:sum3conseq] >10000 then ///for clarity only
[Row-1:sum3conseq] + 10000 + tonumber([value])

elseif tonumber([Value])>0 then
tonumber([Value]) + 10000
else
0

endif

[JBevan89]

Solution Attached

[jfissel]

Spoiler

[TomashevskiiVladimir]

 

[DylanBell]

A quick challenge to practice my speed

[RebekaMazuchova]

:)