Running into a issue with a field aggregation in domo table visual

Utz

Hi I am running into a weird issue in domo table I have multiple metrics inside the table two of the metrics need to be at no aggregation since it is a price and an average of the landed cost, but the rest of the fields need to be summed. Issue I am running into is the first field, which is webretailprice, when that is switched from sum to no aggregation, all fields remain as they are summed up when I switch average landed cost to no aggregation, which is a beast mode calculation "(COGSDollars/(QtyMarketingForecast - QtyCancel - QtySoldout))" It changes all of the metrics to no aggregation

Here are the fields before switching average landed cost to no aggregation

Switching to no aggregation for average landed cost

After Switching to No Aggregation: