Hi! I should be possible. The easiest if you add a tab containers with tabs and then add two tables, one in each tab. in the first one you show everything and in the second you hide the 0 using a display rule.   Another way thou a bit more complicated would be to first create a custom dimension with two values, "show/hide". This can be done by using an existing dimension as input and create two groups. Then add a button bar with dimension as category. Create a text parameter that you add to the button. Then create a calculated measure that checks the value of the parameter and sets the value to . if value of parameter is "hide" and if value is "show" set the value of the original variable that you are using in the table in tour example. Then create a display rule  that change color on values ".", the one you created in your calculated measure.   Maybe this can help you some what 🙂 //Fredrik  ... View more

Hi! I would say that if you want to do calculations using variables from different tables you need to join them. This can be done using built in data prep or before loading data to VA, enterprise guide is my favorite.   If you on the other hand want to subset data using different tables you can link them together in the designer. You need to have the corresponding variable in the tables you're are linking 🙂   //fredrik ... View more

Hi! I don't know the reason for you getting missing values but one thing you really need to be careful with is the length (3:rd argument) you want to keep.   It should never be longer than the original string, i.e if the original string is 30 character you should define the substring like: substr([var],3,28).   We have had a long journey finding why our LASR-server got memory shortage and shut down. The reason was that we used longer substring than the original string, the higher value we used the faster the server went down 🙂   Anyhow, you should get a value from your substring, can you try a short version first, just to see that it works?   //Fredrik ... View more

If you want to change font or background you can create a display rule for each measure that never will be fulfilled and then change the color.   Try create a rule for one measure saying: IF [measure] <> -10000000000 then color background = 'blue' (you do this with point'n ckick :))   In this way it should be possible to set one color for each group. //Fredrik ... View more