Total not working

[TomBond77]

Hi experts

I have the following formula as master item measure:

if(Cap_D_W<>'7', networkdays(Floor(MonthStart(min(Date))), floor(MonthEnd(max(Date))))
, Floor(MonthEnd(Max(Date))) - Floor(MonthStart(Max(Date))) + 1)

How do I get the Sum in the Total row without using the property panel of the measure?

[Mark_Little]

Hi,

Probably first worth checking how it is totaling and set it sum.

[TomBond77]

this is not the same as if it comes automatically from the formula. I fixed it meanwhile: sum(aggr(if(....