The fundamental issue is the field type for
November and
December - I assume it is
Text otherwise you would not be able to add the values of
NA. Met and
Not Met. Your example data is not really helping to understand what you are doing as the original and desired output both have three records and therefore
GroupBy() seems redundant. Is this what you are trying to do ?
ClearCollect(
colGroupedData,
AddColumns(
GroupBy(
colData,
Account,
Parameter,
Act,
FY,
GroupedItems
),
UOM,
First(GroupedItems).UOM,
November,
IfError(
Sum(GroupedItems,Value(November)),
November
),
December,
IfError(
Sum(GroupedItems,Value(December)),
December
)
)
)
I still do not know what UOM is at it does not seem to appear in your desired output.
Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee