I have made an ad hoc report with 12 dimensions and 6 measures for the users to select from, along with a dynamic total (if the user selects dimension 1,3 & 4 then the total is displayed as measure 1+3+4 as so on).
the problem i am facing is that when the measures values are mapped against a null value in dimension, the value is shown in the individual columns but not in the dynamic total. please find a screenshot below and also attached, along with the expression I am using.
Notice the value in Last Row (#N/A)
The total 1 expression is
if(SubStringCount(Concat(ID2,'|'),'M6')>0,[Sales Till Last Cutoff],0)