morning guys

[#1]

can any one help:

is there anything wrong with the following expression:

• Sum({$<MonthID = {“<=$(=Max(MonthID))”}, Year = {$(=Max(Year))}, Quarter = , Month = >} Sales)

[senpradip007]

What is your requirement and what outcome you are getting from this?

[#3]

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.

[petter]

MonthID and Month might be in conflict with each other. The last criteria Month might cancel out the earlier MonthID selection.

[arulsettu]

check this

YTQ, QTD, MTD and WTD

[#6]

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

[arulsettu]

then check this

Previous YTQ, QTD, MTD and WTD

[arsal_90]

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'))

[#9]

Hi Settu,

I m going to have to update the numbers manually?

[sunilkumarqv]

if u have MonthOrderID then use like

• Currernt YTD:
• Sum({$<   MonthOrderID{"$(=Max({<Year={$(=Max(Year))}>}MonthOrderID))"}>} Sales)
• 
  
• Previous YTD:
• Sum({$<   MonthOrderID{"$(=Max({<Year={$(=Max(Year)-1)}>}MonthOrderID))"}, Quarter = , Month = ,Year=>} Sales)