Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Probably first worth checking how it is totaling and set it sum.
this is not the same as if it comes automatically from the formula. I fixed it meanwhile: sum(aggr(if(....