Forum Discussion
Calculated Column - Calculation to Sum based on Date
Hi Experts
Need a calculated column calculation to sum based on dates ( i have sales for the same date) and then divide Amount by Rate values
See sample Data
| Month | Amount | Rate |
| 01/02/2018 | 410.00 | 39475.00 |
| 01/02/2018 | 505.00 | 89704.00 |
| 01/02/2018 | 458.00 | 122174.00 |
| 01/02/2018 | 818.00 | 23857.00 |
| 01/02/2018 | 410.00 | 80644.00 |
| 01/03/2018 | 525.00 | 36850.00 |
| 01/03/2018 | 458.00 | 27825.00 |
| 01/03/2018 | 718.00 | 134855.00 |
| 01/03/2018 | 410.00 | 25143.00 |
| 01/03/2018 | 525.00 | 19537.00 |
| 01/03/2018 | 967.00 | 113036.00 |
| 01/03/2018 | 1369.00 | 72727.00 |
| 01/04/2018 | 1138.00 | 88718.00 |
| 01/04/2018 | 1325.00 | 148039.00 |
| 01/04/2018 | 926.00 | 25400.00 |
| 01/04/2018 | 162.00 | 141660.00 |
| 01/04/2018 | 125.00 | 56406.00 |
| 01/04/2018 | 530.00 | 33250.00 |
Anonymous
Please try this New Column:New Column = DIVIDE( Table3[Amount], CALCULATE( SUM(Table3[Amount]), ALLEXCEPT(Table3,Table3[Month] ) ) )
2 Replies
Anonymous
Please try this New Column:New Column = DIVIDE( Table3[Amount], CALCULATE( SUM(Table3[Amount]), ALLEXCEPT(Table3,Table3[Month] ) ) )