Grand Total Beast Mode not calculating correctly

Options
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
    Options

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

  • jtrollinger
    jtrollinger Member
    Options

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

Categories