GPU: from sales calculate gpu by month, store, transac forecast said GPU from analytics - take into acount itunes544 ....... forecast from bi.accounting take gross, units from bi.analytics take gross, units, paidunits, freeunits, gest, gest_net_of_SC, gest_net_of_SC_no_rd ## RECALL: gest is the following ---------------------------------------------------- gest_no_rd = GG.gpu_using * AA.paidunits gest = if (is_royaltydollar_zero) GG.gpu_using * AA.paidunits else royaltydollar_times_paidunits SET gest = royaltydollar_times_paidunits WHERE (NOT is_royaltydollar_zero) -- FILTER BY paidunits_expected_ratio != 1 -- THEN MULTIPLY gest := gest * paidunits_expected_ratio UPDATE bi.aggregated_analytics SET gest = gest * paidunits_expected_ratio , gest_no_rd = gest_no_rd * paidunits_expected_ratio WHERE (paidunits_expected_ratio != 1) ; ---------------------------------------------------- tmp_DT.split_percs.acc <- DT.acc[, list(OA_gross_forDSOM = sum(gross)), keyby=kCols.splitgroup] tmp_DT.split_percs.anal <- DT.anal[date %ni% unique(tmp_DT.split_percs.acc$date), list(OA_gross_forDSOM = sum(gest, na.rm=TRUE)), keyby=kCols.splitgroup] DT.split_percs.unexpanded <- rbind(tmp_DT.split_percs.acc, tmp_DT.split_percs.anal) [date >= minDateToKeep] Calculate the split percentages OA_gross_forDSOM := sum(gross) when DS is in DT.acc, otherwise summ(gest) when DS is in DT.anal DT.split_percs.unexpanded