topic Using Aggr Function in App Development

Using Aggr Function

jhona1737 — Tue, 21 Dec 2021 21:48:24 GMT

Hello All,

I am trying to get a porcentage by week as shows on the attachement, but I am getting the total porcentage for the month I think I can use Aggr function. This is the scrip I am using

sum({<[Stock transaction type]={'11'},Source country]={'CL'},[Item type]={'320'}>}[Catch weight])/

sum(TOTAL{<[Stock transaction type]={'11'},[Source country]={'CL'},[Item type]={'320'}>}[Catch weight])

Thank you All

Re: Using Aggr Function

raman_rastogi — Wed, 13 Mar 2019 15:02:56 GMT

try this

sum({<[Stock transaction type]={'11'},Source country]={'CL'},[Item type]={'320'}>}[Catch weight])/

sum(TOTAL< Week>{<[Stock transaction type]={'11'},[Source country]={'CL'},[Item type]={'320'}>}[Catch weight])

Re: Using Aggr Function

jhona1737 — Wed, 13 Mar 2019 15:24:39 GMT

Perfect it works!! thank you!