topic set expression in App Development

set expression

Ashutosh11 — Fri, 16 Sep 2022 10:54:22 GMT

I'm trying to find this year's sales quantity of a sub product but showing different value, any help.

Sum({<FiscalYear=, [Date] = {">$(=yearstart(max([Date]), 0,4)) <$(=yearend(max([Date]), 0,4)) "} >}({<[Main Group]={'ITALIAN'}, [Sub Group]={'PU'}>}Quantity))

Re: set expression

martinpohl — Fri, 16 Sep 2022 11:39:49 GMT

Hi,

change to

Sum({<FiscalYear=, [Date] = {">$(=yearstart(max([Date]), 0,4)) <$(=yearend(max([Date]), 0,4)) "} ,[Main Group]={'ITALIAN'}, [Sub Group]={'PU'}>}Quantity))

Re: set expression

SunilChauhan — Fri, 16 Sep 2022 11:42:55 GMT

Sum({<FiscalYear=, [Date] = {">$(=yearstart(max([Date]), 0,4)) <$(=yearend(max([Date]), 0,4)) "} ,[Main Group]={'ITALIAN'}, [Sub Group]={'PU'}>}Quantity)