Hi, so I have a fixed number 96 (its a column on a table, same number in all the rows). I want to be able to calculate a Total based on the number of days in a month. so April would be 30 x 96, January will be 31 x 96.
Please how best do I go about this.
- Please let me know if you need more detail about my model or data.