Above function

[alec1982]

hi,

I'm trying to use above function in a bar chart but it is giving me null..

here is the table i'm using:

QR	Key1	Revenue
4/2013	0	1085.00000000000
1/2014	1	1089.00000000000
2/2014	2	1107.00000000000
3/2014	3	1096.00000000000
4/2014	4	1172.00000000000
1/2015	5	-
2/2015	6	-
3/2015	7	-

and in the chart the dim is QR and EXP=

if(  Key1>4 , above(Revenue) *2 ,Revenue)

[alec1982]

Hi,

Thxs again.. Can you please attach a sample .. it returns Nulls on my side..

Thxs,

Alec

[#3]

try this expression

Label you expression as Rev1

and use the following Expression

if(  Key1>4 , above(TOTAL Rev1) *2 ,Revenue)