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