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?