The total option isn't totaling the column and I dont know why

[jusrober]

Here is the underlying script

(FABS(Sum([Actual Units])-Sum([Forecasted Units]))/Sum([Actual Units]))
*
(Sum([Actual Units])/
Sum(total<[Date]>[Actual Units]))

[andoryuu]

That syntax works in Qlikview but not Qlik Sense.  Placed in the group with the date you don't have to tell it to group by date.  Here's what you need:

=sum(${total} ActualUnits)

If you need to ignore selections in other fields:

=sum(${total<FieldYouWantToIgnore=,OtherFieldToIgnore=>} ActualUnits)

[jusrober]

I appreciate the reply but you are incorrect. The "Total<[Date]>" works as it should. I'm not ignoring fields. I needed it to total by each date and not the total of all the data in the range. The data  below the totals line is correct. I manually checked the math. I just don't understand why the total line isn't adding up those values.

[andoryuu]

If you're already grouping by date why is "sum(${total} ActualUnits)" not a satisfactory denominator...?

[jusrober]

I don't know, but when I put your answer in the number changed a bunch and it didn't fix the total row.