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

Utz
Utz Member
in Cards, Dashboards, Stories

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

image.png

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:

image.png

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

Tagged:

Answers

  • DavidChurchman
    DavidChurchman Coach

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

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • ArborRose
    ArborRose Coach

    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
    image.png image.png

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ArborRose
    ArborRose Coach

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

    image.png

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

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • MichelleH
    MichelleH Coach

    @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
    Utz Member

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

  • Utz
    Utz Member

    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

Categories