Negative values in field

[#1]

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,

[amit_saini]

Janaki,

Check this

Thanks,
AS

[#3]

can you provide script please ,i haven't got lic here at the moment.

[amit_saini · Accepted solution]

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

[jyothish8807]

Hi Janaki,

Simply add an expression sum(Your field). You can use a bar chart.

PFA

Regards

KC

[#6]

THANK YOU AMITH

[amit_saini]

Cheers !

and its Amit    without ->"H"

Thanks,
AS

[Anonymous]

Hi Use the

fabs() function in the expression

like

=Fabs(Sum(Sales))