Hi everyone could you halp me !?!?! I have a question regarding calculating averages between dates in my dataset. this is an example of my dataset: DTCONT CTV_SALDO 01SEP2022 145.026,70 02SEP2022 146.204,88 05SEP2022 147.946,40 06SEP2022 147.999.752,70 07SEP2022 152.085.201,11 08SEP2022 154.195,98 09SEP2022 149.789.820,12 12SEP2022 141.755.850,87 13SEP2022 140.970.282,19 14SEP2022 143.708,69 15SEP2022 140.896.452,76 16SEP2022 138.298.019,82 ... ... 30SEP2022 141.237,33 in my dataset there isn't saturady and sunday; i had to include !! the balance of saturday (3th) and sunday (4th) is the same of friday (2th) i had to calculate an average based on mounth (e.s september, 30 days). so i had to sum the balances of each day of the mounth. the problem is: my extraction is without saturday and sunday (but also there isn't the 25th december, 1° january, ect.). so, i want to realize this table: Date CTV_SALDO 01SEP2022 145.026,70 02SEP2022 146.204,88 saturday 146.204,88 i had to insert date and import the same friday sunday 146.204,88 i had to insert date and import the same friday 05SEP2022 147.946,40 06SEP2022 147.999.752,70 07SEP2022 152.085.201,11 08SEP2022 154.195,98 09SEP2022 149.789.820,12 saturday 149.789.820,12 i had to insert date and import the same friday sunday 149.789.820,12 i had to insert date and import the same friday ... ... 30SEP2022 141.237,33 avarage to calculate --> ______________ sum balances in each day/30 is there a command to insert saturday and sunday? at the same time, i had to insert the same balance of friday in saturday and sunday thanks for you helping !!
... View more