I created a island-table to create an scaling factor (i.e. Million, Thousand, Full). When using this field in my Set Analysis, it does not work properly. when the end-user select the scaling factor, for example Million, the formula, the highlighted one in yellow, just calculates the number correctly for the period selected and not for the other ones. Any idea?