my question is as follows: i cant seem to upload the file
i took my data of amounts and group types and service months
the query's columns were computed - first i grouped by service month and type group and then by participant with an output of sum of amount column per type per month per participant
then amount is the actual sums of billed amount, units is amount divided by 10 then extracted before the decimal, total is units x 10, rollover is amount minus total
i pivoted nicely
but i am missing the most important element
the rollover needs to keep being added to the next months amount which is then manipulated as above meaning the new amount then needs to be divided by 10 etc. and then at the end there may be a rollover which needs to be added to the next months total
services are divided by service month and group type and participant
can that be done?
i took my data of amounts and group types and service months
the query's columns were computed - first i grouped by service month and type group and then by participant with an output of sum of amount column per type per month per participant
then amount is the actual sums of billed amount, units is amount divided by 10 then extracted before the decimal, total is units x 10, rollover is amount minus total
i pivoted nicely
but i am missing the most important element
the rollover needs to keep being added to the next months amount which is then manipulated as above meaning the new amount then needs to be divided by 10 etc. and then at the end there may be a rollover which needs to be added to the next months total
services are divided by service month and group type and participant
can that be done?
