Summing columns using expressions in a straight table vs sum of rows

[jworthulf]

On the attached example I need some help formatting the expression for Route Fixed Cost.     When a routeID is selected the fixed cost column is populating correctly.    However if I do not use a route ID filter the cost field does not populate.

I want to take the Route Fixed Cost * # Routes and sum this using an expression vs sum of rows.

[Nicole-Smith · Accepted solution]

I think the aggr() in your expression might be the issue.

I tried this and I think it might work for you:
rangesum(count(distinct ship_dt)*RouteFixedCost)