SUM Lineitems by Weekday

Occasional Contributor

SUM Lineitems by Weekday

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?

3 REPLIES 3
Master Anaplanner/Community Boss

Re: SUM Lineitems by Weekday

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 ugly 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

Moderator

Re: SUM Lineitems by Weekday

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

Occasional Contributor

Re: SUM Lineitems by Weekday

OK, I understand！

Thankyou！