# SUM Lineitems by Weekday

Options

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?

Tagged:

• Options

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,

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

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

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

Thanks

Arun

• Options

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

• Options

OK, I understand！

Thankyou！