You’re offline. This is a read only version of the page.
302
Share
ReportGroupBy(AddColumns(Grants,"ProjectText",Project.Value),"ProjectText","Data")The expression was intended to add a new column named "ProjectText" to the "Grants" table, with the values coming from the "Value" property of the "Project" record. After adding this column, the expression aims to group the resulting table by the "ProjectText" column and create a nested table with the grouped data under the column name "Data".
However, there are several errors in the expression:
1. **Expected identifier name**: This error indicates that the function is expecting a valid identifier (like a variable name) but is encountering something else, likely due to the use of `StringLiteral` instead of a direct string name.
2. **The function 'AddColumns' has some invalid arguments**: This suggests that the arguments provided to the `AddColumns` function are not correctly formatted or are not valid. Specifically, the use of `StringLiteral` for the column name is incorrect.
3. **The function 'GroupBy' has some invalid arguments**: Similar to the previous error, this indicates that the arguments for the `GroupBy` function are not valid, again likely due to the incorrect use of `StringLiteral` for the column names.
To fix these errors, the `StringLiteral` functions should be replaced with direct string literals for the column names.
All responses (
Answers (
GroupBy(
AddColumns(
Filter(
Grants,
Project.Value = Gallery1.Selected.Project.Value
),
ProjectText,
Project.Value
),
ProjectText,
Data
)GroupBy(
AddColumns(
Grants,
ProjectText,
Project.Value
),
ProjectText,
Data
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
