Set Analysis Issue in Straight Table using Variable
I'm stuck trying to figure out why my Set Analysis expression is not dynamically calculating for each dimenional value when using a variable and dollar sign expansion. My chart only has one dimension. My expression is using aggrs with other dimensions not found in the chart but does calculate without issue when I use it in the expression.
I've tried variations using single quotes, double quotes, etc. The only time it calculates the correct value is if I actually select only 1 dimensional value. Otherwise, it repeats the same calcuation for each row.
Anyone have some advise on why this is not working? Thanks!
Re: Set Analysis Issue in Straight Table using Variable
Thanks for your quick response - I mocked up fictious data in this example so I expect to find some issues with null values but even if I add the value "10" to the Lookup Table, it still comes back with null in the yellow column for all rows. I need it to return "40" for the row with the value of "C" and null or 0 for all other rows since they don't have a match to the Lookup.