Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can any one help:
is there anything wrong with the following expression:
What is your requirement and what outcome you are getting from this?
Hi Sen,
my requirements is to get Year_To_Date(YTD):
I think there is something wrong with the expression as it populate dashes on the filed.
MonthID and Month might be in conflict with each other. The last criteria Month might cancel out the earlier MonthID selection.
check this
Hi Settu,
I have the YTD,QTD,MTD and WTD but I want the previous period:
LYTD, LQTD, LMTD, PRIOR_YEAR_MTD, LWTD and PRIORYEAR_WTD
then check this
YTD Previous:
num(SUM({<Year={'$(vPriorYear)'},Month=,Day=,Num={'<=$(vPriorYearDate)'},MonthYear=,Quarter=,Flag={'Actual'}>}[Net Sales]),'##,##0')
vPriorYear=(vMaxYear) -1
vPriorYearDate=num(date(addyears(max(Num), -1), 'DD MMM YYYY'))
Hi Settu,
I m going to have to update the numbers manually?
if u have MonthOrderID then use like