Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys! This is quite a simple question.
Basically, i have a DISCOUNT table, with 3 different DISCOUNT values, namely 0.7, 0.6 & 0.5.
I added this DISCOUNT dimension into a chart. so now what i want is that, when the discount is clicked to 0.7, the value under the DISCOUNT dimension in the chart be changed to 30%.
1)DISCOUNT table click 0.7
2)DISCOUNT dimension in chart, valu is shown as 30%.
is there any formula to make this happen ?
Thanks in advance! =p
Hi Nitesh,
You can use in the chart dimension as follows:
if(DISCOUNT<=1,(1-DISCOUNT)*100)
Hence,when you click 0.7 , it will calculate as (1.0-0.7)*100 = 30
Hope,this works..
Hi Nitesh,
You can use in the chart dimension as follows:
if(DISCOUNT<=1,(1-DISCOUNT)*100)
Hence,when you click 0.7 , it will calculate as (1.0-0.7)*100 = 30
Hope,this works..
Hi Rahul, thanks for the reply!
This solution is not entirely correct, the correct one is,
1) if(DISCOUNT<=1,(1-DISCOUNT))
2) go to NUMBER, choose the DISCOUNT EXPRESSION, click FIXED TO, Under FORMAT PATTERN, type #,##0, then click the SHOW IN PERCENT (%) box.
Thanks!!
And another thing, this works for every value, other than 1.
Can i ask for a help, can you give me an expression which has,
if(DISCOUNT<=1,(1-DISCOUNT))
and also including an expression which is, when Discount = 1, the data displayed would be, NO DISCOUNT.
can this be done ?