Hi I had question about a basic beast mode calculation that is not behaving correctly

Utz · 2025-06-05T20:52:12+00:00

There was an error rendering this rich post.

My beast mode calculation is here which is delivered margin define / qtymarketingforecast :

Here are the result but as you can see if you divide the delivered margin $ from qty marketing forecast you end up with a different value then you are supposed to:

Not sure what is causing the results to be off since the beast mode calculation is straight forward.

Find more posts tagged with

Beast Mode

Accepted answers

MichelleH

@Utz I generally recommend aggregating the numerator and denominator when using division in Beast Mode like this:

sum(`DeliveredMarginDefine`) / sum(`QtyMarketingForecast`)

Otherwise, the card is dividing each dataset row first before then summing them, resulting in unexpected outputs.

All comments

DavidChurchman

It looks like Delivered Margin Define is coming from a different BeastMode. What does that BeastMode look like? It is probably the culprit.

ArborRose

Using:

Year,Season,VendorName,QtyMarketingForecast,DeliveredMarginDefine

2025,Spring,Vendor1,580,-68.23

2025,Spring,Vendor2,276,2548.93

2025,Summer,Vendor3,142,1050.75

2025,Fall,Vendor4,833,763.5

2025,Winter,Vendor5,902,-400

ArborRose

Even if I used the formula as you showed it, it should have worked. Are your fields numeric?

Example above would give the same output I showed in my formula screenshot.

MichelleH

@Utz I generally recommend aggregating the numerator and denominator when using division in Beast Mode like this:

sum(`DeliveredMarginDefine`) / sum(`QtyMarketingForecast`)

Otherwise, the card is dividing each dataset row first before then summing them, resulting in unexpected outputs.

Utz

Thank you @MichelleH this worked I should have tried to sum them up myself but thank you for the help as always!

Utz

Thank you @DavidChurchman @ArborRose for the quick response yes both the fields were numeric and the delivered margin define function was just if delivered margin new = 0 then delivered margin else delivered margin new