Good morning. I have a Combo Chart / Straight Table fast change object showing Sales and Target with Year Period as a dimension. In the Combo Chart I change the Sales bar background color to be green if the Sales are greater than the Target. '=If(Sum(Sales) > Sum(Target), Green() )' This works fine. However, when I change to Straight Table I need the text to change to white. From what I can see a straight table is a object type 11. The question is, is there a way in the Expression Text Color that I can find the object type? For example, what I am looking at saying in the text color is, if the Object type = ??? White() ....
I would really appreciate any possible solution to this.
AFAIK the object-type information isn't natively readable from the UI. To get such information you will need macros. In general could macro-functions be enabled within the easter egg but it's not recommended. If the macro way should be used it would be probably better to write the information in a variable which could be used in your expressions.
Beside the above you may try functions like rowno(), columnno(), dimensionality/secondarydimensionality() or similar to look if they return a different result in regard to the object-type.
