topic Pivot Table Error with Unicode Objects - Colour missing in App Development

Pivot Table Error with Unicode Objects - Colour missing

GrantBooth — Wed, 24 Nov 2021 03:46:20 GMT

Having the strangest problem with pivot tables and unicode objects.

I have a Pivot Table with six dimensions and five columns. The 5th column is a conditional statement

if($(v.MTD(Actual)) < $(v.MTD(Budget)), chr(10060), chr(9989))

What is strange is that most of the time the unicode objects appear black and white, it is only when a user hovers over an item, or the pivot table is collapsed fully, do we see any colour. I also have several other Pivot Tables which all have the same problem. This is a new issue which did not exist when the table was built.

I've checked text colour expression for the measure and it's blank, so that's not the problem, and I've tried creating new ones from scratch and they have the same problem. There are no issues with colour anywhere else in the app.

Re: Pivot Table Error with Unicode Objects - Colour missing

marcus_sommer — Wed, 24 Nov 2021 13:29:21 GMT

Your comparing of $(v.MTD(Actual)) < $(v.MTD(Budget)) could be invalid on the TOTAL levels and returning then NULL. This could happens if not all calculation-parts of your variables are aggregations, for example by querying there something like: if(AdType = ... On the granular level this could be resolved but on the TOTAL there are then multiple values available and causing the NULL which forced the whole expression to NULL.

In such a case you will need to wrap the condition with an aggr() like:

if(sum(aggr($(v.MTD(Actual)) < $(v.MTD(Budget)), AdType)), this, that)

- Marcus

Re: Pivot Table Error with Unicode Objects - Colour missing

GrantBooth — Wed, 24 Nov 2021 23:04:15 GMT

What are you referring to with AdType?

Re: Pivot Table Error with Unicode Objects - Colour missing

GrantBooth — Wed, 24 Nov 2021 23:21:30 GMT

The formula used wasn't returning NULL anywhere, this was tested by using the same logic in text colour expression using

if($(v.MTD(Actual)) < $(v.MTD(Budget)), red(), green())

I was able to solve the problem by using this expression in conditional text colour in column with the emoji.