topic Re: dynamic vs non-dymanic set analysis: making something not change with filters in App Development

dynamic vs non-dymanic set analysis: making something not change with filters

kailafisher — Sat, 16 Nov 2024 02:07:29 GMT

hello,

i have the following expression:

round(((SUM({<Product={"=sum(TotalCost)>=$(=max(aggr(sum(TotalCost),Product),3))"}>}TotalCost)) / sum(TotalCost))*100, .01) & '% of Total Cost'

right now what its doing is taking the top 3 highest cost products and finding what percentage of total cost that they collectivley occupy. I need to make the sum(TotalCost) at the end "not dynamic" so when the filters are in place my function will still divide by the whole total cost of every product in my database.

i have tried a combination of ALL, TOTAL, {1} but nothing is working please help!!

Re: dynamic vs non-dymanic set analysis: making something not change with filters

Vegar — Thu, 18 Jun 2020 04:40:51 GMT

The expression

sum({1}TotalCost) should give you the total you are looking for. If you are using it in a object with dimensions you might want to puy in a total as well. Like this : sum({1}TOTAL TotalCost)

Re: dynamic vs non-dymanic set analysis: making something not change with filters

kailafisher — Thu, 18 Jun 2020 16:26:18 GMT

hmm yes i tried that before and it didnt work... i do not know why

Re: dynamic vs non-dymanic set analysis: making something not change with filters

sunny_talwar — Thu, 18 Jun 2020 16:38:41 GMT

So, to be clear, you are getting the right number from your numerator expression?

Sum({<Product ={"=Sum(TotalCost) >= $(=Max(Aggr(Sum(TotalCost), Product), 3))"}>} TotalCost)

you only have issues with your denominator only?

Sum(TotalCost)

Or do you really want this for numerator

Sum({<Product ={"=Sum(TotalCost) >= $(=Max({1} Aggr(Sum({1} TotalCost), Product), 3))"}>} TotalCost)

and this for denominator

Sum({1} TotalCost)