Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Try like below
Sum({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >} Aggr( only({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >}Input_SQFT),WO_WorkOrderNo,[Time - Month]))
I believe that is because you have not include your set expression with the AGRR function to ignore your selections
When I don't use Aggr, the value is incorrect. What do I have to do?
Hi
Try like below
Sum({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >} Aggr( only({<TypeStatus={'OUTER'},[Time - Month]= ,[Time - Day]= >}Input_SQFT),WO_WorkOrderNo,[Time - Month]))
thank you very much