1 Reply Latest reply on Nov 19, 2018 4:22 PM by Yuri Fal

# Repeat result for non null result in all other rows

Good Morning  Community,

I have a data table with daily data and a value for each day.  What I'm trying to do is create a calculation that finds the third tuesday of every month.  I have successfully created the calculation to do this.  What I am struggling with is I need it to return the value for every day thereafter until the next third Tuesday of the month at which time the value should change to the new value.

Here is my calculation to get the third Tuesday value returned:

If Day([Report Date])>=15 AND Day([Report Date])<=21 AND DATENAME('weekday',[Report Date])="Tuesday" Then [Avg Mostly] END

I have attached the workbook.

So in the sheet you can see we have the report date and then the contract price that is calculated for every day so it repeats correctly.  Then we have that same contracted price calculation, but using our third Tuesday of the month calculation so it only shows for each Third Tuesday of the month, I need it to calculate for each day and then change each third Tuesday of the month.  I hope that makes sense.

Any help would be greatly appreciated!!!!  Thank you in advance!

• ###### 1. Re: Repeat result for non null result in all other rows

Hi Tom,

The approach i've been using so far

is not for the faint-hearted :-)

The idea is to have (overlapping) LOD 'Frames'

to calculate the necessary values for all those Frames,

then use the results (at the Row Level) to fill the values into the (adjacent) rows.

This all is a FIXED LOD-heavy stuff, so the performance issues may occur.

Please refer to the recent thread for the similar problem / solution / discussion:

Re: Distinct active users in prior 90 days for a given week