Skip to Content
1
Dec 08, 2021 at 09:07 AM

Shifting data between days

99 Views

Hello,
I want to shift data by "almost a full year" by day.

I can easily make it that way, when the parameter needed is for example 355 days

DATA()=
RESULTLOOKUP([d/Version]="public.Actual", [d/Date]=PREVIOUS(%P_03_DAYS_QTY%,"DAY",[d/Date]))

however what I try to do is the have "365 days" fixed and the have only the difference of days as a parameter

for example instead of 355, the 365 is fixed and the parameter is minus 10

trying this formula I get an error (see attached)

DATA()=
RESULTLOOKUP([d/Version]="public.Actual", [d/Date]=PREVIOUS((365+%P_02_DAYS_QTY%),"DAY",[d/Date]))

trying this formula it seems like it's validate, but the result completely ignore the second resultlookup, and shifts the data 365 day only

DATA()=
RESULTLOOKUP([d/Version]="public.Actual", [d/Date]=PREVIOUS((365,"DAY",[d/Date]))+
RESULTLOOKUP([d/Version]="public.Actual", [d/Date]=PREVIOUS(%P_02_DAYS_QTY%,"DAY",[d/Date]))

How can I do that?

by the way my memberset for day is a full year range and not a day.

Thanks

Deb

seaseror.png



Attachments

seaseror.png (21.3 kB)