Multiple text Color for expressions in Single Cell.

[rahulsud007]

Dear All,

We have a requirement in which we need to show multiple text colors as shown in the pic.

From Image,

For 2015 Budget the 287.1 is the the value  sum(Budget For that month).

chr(10) to bring next expression to next line.

ie  -3.6%(in Red Color).

The next expression (sum(Actual for that month)/sum(Budget For that month))-1 if the value is <0, red, else green.

Also attaching a sample QVW.

Is there any way how we can achieve this?

Please help.

Thanks in advance..

[marcus_sommer]

It's not possible to have more then one color, font and so on in one single cell - you will need to split into two rows per each dimension-value.

- Marcus

[jagan]

HI,

it is not possible to display multi colors with in a single cell, instead you can display them in different cells/rows and format it accordingly.

Regards,

jagan.

[rahulsud007]

Hi Marcus,

Thanks for your advice. Can you please let me know how we can split a single expression in to multiple rows?

[jyothish8807]

Hi Rahul,

This not possible in your case, try using a pivot table then it can be easily achieved.

Regards

KC

[rahulsud007]

Hi Jagan,

Can you help us with an sample of what u r saying (ie formatting row wise/ cell wise)?

Thanks..

[rahulsud007]

HI KC,

It is in Pivot table.

But  I am not getting it.

[marcus_sommer]

You could add a second calculated dimension maybe with a valuelist like:

valuelist('values', '% from x')

and in your expressions something like:

if(valuelist('values', '% from x') = 'values', sum(YourValuesExp), sum(YourPercentExp))

- Marcus

[jyothish8807]

Right now you have created all the calculation in one expression. Try to break them into multiple expressions. Then you will have different entries for Actual, budget and others. Then you can do color formation on expression level.

Regards

KC