topic Re: I want to show every month. in App Development

I want to show every month.

Sxbbb — Fri, 15 Nov 2024 21:32:25 GMT

I use code :

Sum({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >} Aggr( Input_SQFT,WO_WorkOrderNo,[Time - Month]))

Result :

Values are displayed for only the selected month. But I want to show every month.

If selecting a month The value must still show every month.

What do I have to do?

Re: I want to show every month.

Mark_Little — Wed, 26 Jul 2023 08:35:54 GMT

I believe that is because you have not include your set expression with the AGRR function to ignore your selections

Re: I want to show every month.

Sxbbb — Thu, 27 Jul 2023 03:21:10 GMT

When I don't use Aggr, the value is incorrect. What do I have to do?

Re: I want to show every month.

MayilVahanan — Thu, 27 Jul 2023 03:45:33 GMT

Try like below

Sum({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >} Aggr( only({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >}Input_SQFT),WO_WorkOrderNo,[Time - Month]))

Re: I want to show every month.

Sxbbb — Thu, 27 Jul 2023 08:14:18 GMT

thank you very much