topic Re: Sum Aggr expression Issue in App Development

Sum Aggr expression Issue

oscarvictory — Mon, 20 Dec 2021 21:08:46 GMT

Hi all, hope you can help me with this little issue.

Here is a table where COST column is the result of FACT_DPT/FACT_TOT * TOT_COST:

(SUM({1<ANYOlinfact={$(=vActualYear)}, PROFIT ={"Eat"}, TYPE ={"COST"}, Cost = {">0"}>} factlin* Price))

(SUM({1<ANYOlinfact={$(=vActualYear)}, TYPE ={"COST"}, PROFIT -={"Dora"}, Cost = {">0"}>} factlin* Price) - (Sum({1<TYPE ={ 'COM'}, CodCli = {2447}>} Cost)))

* Max({<TYPE ={"COST"} >} Cost)

Problem arise when I insert above formula into Pivot Table containing Customer & Month.

((Sum(aggr(SUM(total{1<ANYOlinfact={$(=vActualYear)}, PROFIT ={"Eat"}, TYPE ={"COST"}, Cost = {">0"}>} total <MONTH > factlin* Price), MONTH, CUSTOMER )))

Sum(aggr(SUM(total{1<ANYOlinfact={$(=vActualYear)}, TYPE ={"COST"}, PROFIT -={"Dora"}, Cost = {">0"}>} total <MONTH > factlin* Price)- Sum(total{1<TYPE ={ 'COM'}>} Cost),MONTH, CUSTOMER))

* aggr(sum(total{1<TYPE ={"COST"} >} Cost), MONTH, CUSTOMER ))

Many TKS in advance.

Re: Sum Aggr expression Issue

marcus_sommer — Mon, 26 Oct 2020 12:57:25 GMT

Try it in this way:

Sum(aggr(
(SUM({1<ANYOlinfact={$(=vActualYear)}, PROFIT ={"Eat"}, TYPE ={"COST"}, Cost = {">0"}>} factlin* Price))

(SUM({1<ANYOlinfact={$(=vActualYear)}, TYPE ={"COST"}, PROFIT -={"Dora"}, Cost = {">0"}>} factlin* Price) - (Sum({1<TYPE ={ 'COM'}, CodCli = {2447}>} Cost))) * Max({<TYPE ={"COST"} >} Cost),
MONTH, CUSTOMER ))

- Marcus

Re: Sum Aggr expression Issue

oscarvictory — Mon, 26 Oct 2020 13:25:03 GMT

Perfect Marcus!!. Many Thanks!!.