Reporting on variables with aggregate (sum) on the values on a variable.

[Community Alums]

I have two variables coming in from a Record Producer into a matter record. I need a report where in I group by variable A (which I can in the report) and I need to get the aggregate(sum) of the second variable B. However, the variable does not appear in the dropdown for selection for the aggregation (SUM) (only matter table fields are available).

I am looking for a solution to this.

Variable is a  'Single Line Text' with Validation Regex set to 'Number'.

I also tried the database view, however, I am not able to select the value field either.

[Sanjay191]

Hello @Community Alums 
Are you apply aggregate on variable B or variable A could you give me more explanation on this usecase?

Thank You

[Community Alums]

Hi Sanjay, I am trying to get aggregate SUM on the second variable, which is a Single Line Text Type and have a validation Regex - Number. [This variable is used to hold fee values like 5000, 600]