Grand Total Beast Mode not calculating correctly

jtrollinger
jtrollinger Member
in Cards, Dashboards, Stories

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

image.png

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

  • Jones01
    Jones01 Contributor

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

  • jtrollinger
    jtrollinger Member

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

Categories