Highlight Number in Chart

[Fiorrie]

Hi Everyone

How can I add condition to put negative values in red please? The below is not working, my numbers are shown in % (its QoQ).

IF($(vMeasure03) = 'QoQ', $(vSalesTrendRev) > 0, red(),'')

Many thanks

[sunny_talwar · Accepted solution]

May be you need nested if here

If($(vMeasure03) = 'QoQ',
   If($(vSalesTrendRev) > 0, Red())
)

[Fiorrie]

Unfortunately not working, it is showing 0% everywhere

[sunny_talwar]

0%? This is a color expression, right? I hope you are using this not as your main chart expression 🙂

[Fiorrie]

Ah thanks a lot, its working now (too many hours of development 🙂 )

[Fiorrie]

Also perhaps, any chance you could help with this? I have two codes and I would like to connect them to show only current week of historical data in KPI.

Many thanks

Historical data

(RangeSum(Above(TOTAL Sum({$<[qtr_flag]={1},qtr=>}revenue),0,RowNo(Total)))+
RangeSum(Above(TOTAL Sum({$<[qtr_flag]={2},qtr=>}revenue),0,RowNo(Total)))+
RangeSum(Above(TOTAL Sum({$<[qtr_flag]={3},qtr=>}revenue),0,RowNo(Total))))
/
Sum(Total<qtr>{$<qtr_flag={1,2,3},qtr=>}revenue)

 Current Week

=MAX({$<qtr_flag={0}>}inv_week)

[sunny_talwar]

May be this

(RangeSum(Above(TOTAL Sum({$<[qtr_flag] ={1}, qtr, inv_week = {"$(=Max({$<qtr_flag={0}>} inv_week))"}>} revenue), 0, RowNo(TOTAL))) +
RangeSum(Above(TOTAL Sum({$<[qtr_flag] ={2}, qtr, inv_week = {"$(=Max({$<qtr_flag={0}>} inv_week))"}>} revenue), 0, RowNo(TOTAL))) +
RangeSum(Above(TOTAL Sum({$<[qtr_flag]={3},qtr, inv_week = {"$(=Max({$<qtr_flag={0}>} inv_week))"}>} revenue), 0, RowNo(TOTAL))))
/
Sum(TOTAL <qtr>{$<qtr_flag = {1,2,3}, qtr, inv_week = {"$(=Max({$<qtr_flag={0}>} inv_week))"}>} revenue)

[Fiorrie]

Still showing the last week (13) which is 100%, I dont get it why it is not able to link, when I look at the week separately it is showing me correctly week 9.

[sunny_talwar]

Can you show with images as to what you see and explain as to what the issue is?

[Fiorrie]

So I want to show 62% next to 59% (actual), the long code belongs to the chart on the right, but I am still getting the last week 100% (even when I put it in the table it is nicely showing me % per weeks separately)