Pessoal, bom dia!
Estou tentando calcular o crescimento em % mês a mês e ano a ano. Criei o calendário abaixo:
****************************************************
LET varMinDate = Num(peek('DATA', 0, 'VB_por_Tipo'));
let varMaxDate = Num(Peek('DATA', -1, 'VB_por_Tipo'));
let varToday = num(today());
//********************Temporary Calendar*******************//
DateField:
LOAD
$(varMinDate) + rowno() - 1 as Num,
date($(varMinDate) + RowNo() - 1) as TempDate AutoGenerate
$(varMaxDate) - $(varMinDate) + 1;
//********************Master Calendar***********************//
MasterCalendar:
LOAD
TempDate as DATA,
Week (TempDate) as Week,
Year (TempDate) as Year,
Month (TempDate) as Month,
Day (TempDate) as Day,
Weekday (TempDate)as WeekDay,
'Q' & ceil (month(TempDate) / 3) as Quarter,
Date (monthstart(TempDate), 'MMM-YYYY') as MonthYear,
Week (TempDate) & '-'&Year(TempDate) as WeekYear,
inyeartodate (TempDate, $(varToday), 0) * -1 as CurYTDFlag,
inyeartodate (TempDate, $(varToday), -1) * -1 as LastYTDFlag
resident DateField order by TempDate ASC;
drop table DateField;
Ele funcionou corretamente, mas quando estou colocando a fórmula sum({$<MonthYear={$(=Only(MonthYear))}>} VB) na expressão, está retornando zero. Podem me ajudar identificando onde estou errando?
