Cards, Dashboards, Stories

Cards, Dashboards, Stories

Grand Total Beast Mode not calculating correctly

The beast mode below is not calculating correctly in the Grand Total Column.

CASE WHEN SUM(IFNULL(`Billed Amount`,0)) = 0

THEN 0

ELSE

(((SUM(IFNULL(ABS(`Billed Amount`),0))) - (SUM(IFNULL(`Actual Material Cost`,0)) + (SUM(IFNULL(`Actual Labor Cost`,0))))))

/

SUM(IFNULL(`Billed Amount`,0))

END

Answers

  • Contributor

    @jtrollinger the image isn't great quality but try removing the field you have in the Sort section.

  • Please disregard this question I had my ( ) in the wrong place within my beast mode.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In