IsUP function with multiple timeframes, not working well.

Optuma Scripting
1

“isUp” function works fine for any individual timeframe but when you combining multiple TF to get a consolidated result, it’s not working well (cf attachment)

Full Time Frame Continuity (FTFC):
YEAR() IsUp and MONTH(PERIODAMOUNT=3) IsUp and MONTH(PERIODAMOUNT=1) IsUp and WEEK() IsUp and DAY() IsUp

FTFC-.jpg
FTFC-.jpg950×1360 222 KB

2

Hi Marc,

When combining timeframes in one formula you need to start with the lowest timeframe first. Try this:

DAY() IsUp and WEEK() IsUp and MONTH() IsUp and MONTH(PERIODAMOUNT=3) IsUp and YEAR() IsUp