Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i got both negative and positive values in field how to distinguish them like positive,negative, Sum(positive and negative) .
give me some examples please.
thanks,
Suppose this is your script:
load * inline [
A, B
a,-1
b,-2
c,-1
d,-3
e,-4
];
Now create a bar charts with A as dimmenison and =fabs(sum(B)) as expression for negative values.
So in this way you can show both -ve and +ve values in two different bars.
You can create one more filed as "C" in script with positive numbers and check as Sum(c)
Thanks,
AS
Janaki,
Check this
Thanks,
AS
can you provide script please ,i haven't got lic here at the moment.
Suppose this is your script:
load * inline [
A, B
a,-1
b,-2
c,-1
d,-3
e,-4
];
Now create a bar charts with A as dimmenison and =fabs(sum(B)) as expression for negative values.
So in this way you can show both -ve and +ve values in two different bars.
You can create one more filed as "C" in script with positive numbers and check as Sum(c)
Thanks,
AS
Hi Janaki,
Simply add an expression sum(Your field). You can use a bar chart.
PFA
Regards
KC
THANK YOU AMITH
Cheers !
and its Amit without ->"H"
Thanks,
AS
Hi Use the
fabs() function in the expression
like
=Fabs(Sum(Sales))