SUM Lineitems by Weekday

hyudolee

I want to calculate the amount by Weekday.

This is the image.

Module A

List	Day	2021/1/1	2021/1/2	2021/1/3	2021/1/4	2021/1/5	2021/1/6	2021/1/7	2021/1/8
LineItem	Weekday	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon
LineItem	AmountA	100				10			50

Module B

List	Weekday	Mon	Tue	Wed	Thu	Fri	Sat	Sun
LineItem	AmountB	150(100+50)				10

 

I tried this formula but the Monday Total has not calculated.(Amount = 0) 

Formula: Amount B = AmountA[SUM:Weekday]

 

How can I calculate it?

ArunManickam

Can you raise this to support, defintely i would expect this to work with your formula.

It is probably due to how the standard time list is special and is not same like other dimensions.

 

Here is a **** work around,

In your source,

create another line item, say'~A' and dimension it by Time(Day) and Weekday list.

If weekday = item(weekday list) then AmountA else 0

 

In your target module,

'~A'[Select:time.all periods]

 

Thanks

Arun

Misbah

@hyudolee 

 

If you have a Time Dimension in your source module and not in target module then you can not use SUM in Target module based on Time in Source module because of the special nature of Time dimension in Anaplan as @ArunManickam mentioned.i.e., Every Time Item is considered to be in separate block (Analogy to Line item) & SUM doesn't worn Interblock.

 

Misbah

hyudolee

OK, I understand！

Thankyou！