Grand Total Beast Mode not calculating correctly

Options
jtrollinger
jtrollinger Member
in Dashboards

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