SUM Lineitems by Weekday

hyudolee
Occasional Contributor

SUM Lineitems by Weekday

I want to calculate the amount by Weekday.

This is the image.

Module A

ListDay2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/72021/1/8
LineItemWeekdayMonTueWedThuFriSatSunMon
LineItemAmountA100   10  50

Module B

ListWeekdayMonTueWedThuFriSatSun
LineItemAmountB150(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
ArunManickam
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,

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
Moderator

Re: SUM Lineitems by Weekday

@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
Occasional Contributor

Re: SUM Lineitems by Weekday

OK, I understand!

Thankyou!