If I use this expression I receive want I need and is ok (see below second field). I created a variable with this expression because I want to use it to filter other data (charts, tables) (see below the first field).
The issue is when I use the variable with the same expression as above I receive only the value "1" for all fields. I know I'm doing something wrong and I would like to know what
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?