I want to use the result of the calculated field as part of a second expression and from I know I can't use a master dimension on a expression. For example:
SUM(if (isnull([asp_date_end_FRS]),1,asp_date_end_FRS)Value), I just want to add values if the cell on "asp_date_end_FRS" field is blank. Maybe you can point to another solution to select only blanks and add other fields based on this selection?
I'd try to do it in the sccript:
example, I have a field dim1 where I have some null values:
Load *, dim1 as YourNewDim from source where dim1<>'' or dim1<> '-' or len(trim(dim1))> 0 //dpends on how ur null values are
load * ,'1' as YourNewDim from source where dim1='' or dim1= '-' or IsNull(dim1) or len(trim(dim1))= 0 ;
and use YourNewDim in your analysis !
Hope this helps