Hi,
I’m trying to dynamically get forecast data for all months after next quarter, with previous month as standpoint.
E.g. now, previous month was in Q1, hence I would want data for YearMonth 202107 forward.
Feels like I need some conditionality here but I don’t know how to do that in this syntax, i.e.:
if Month(Today()) is 2, 3 or 4 then return summed months from current year month 7 forward
if Month(Today()) is 5, 6 or 7 then return summed months from current year month 10 forward
if Month(Today()) is 8, 9 or 10 then return summed months from next year month 1 forward
if Month(Today()) is 11, 12 or 1 then return summed months from next year month 4 forward
I have fields Quarter and YearQuarter like (Q1, Q2, Q3, Q4) and (2021Q1, 2021Q2…) but I don’t think I can use Date(Today()) with those? I mean something like:
=Sum({<YearMonth ={">=$(=YearQuarter(Date(Today(),'YYYYMM')-1)+2)"},>}kWh)/Volume
Cheers,
Robin