How to get positive values and negative values separated?

[#1]

Hi All,

The below table box is the output I am getting

The average value is the output based on date and value

Name	Date	Value	Avg.Value.
A	1/1/2017PM	4	0
B	1/2/2017PM	7	0.75
C	1/3/2017PM	4	-0.42
D	1/4/2017PM	3	-0.25

The expression to get average value based on below formula:

Num((Sum(Rolling_7_days.Counts)-above(TOTAL sum( Rolling_7_days.Counts ) ))/above(TOTAL sum( Rolling_7_days.Counts ) ),'#,##0.00')

According to the Formula.

(Today-Previous day)/Previous day)*100)/Previous day)*100)/Previous day)*100)/Previous day)*100)/Previous day)*100)/Previous day)*100

Name B:

Today=1/2/2017                value:7:7

Previous day=1/1/2017      value:  4

Formula:

(7-4)/4=0.75

Name C:

Today=1/3/2017                value:4:4:4

Previous day=1/2/2017      value:  7

Formula:

(4-7)/7=-0.42

NameD:

Today=1/4/2017                value:3:3:3

Previous day=1/3/2017      value:4:4:4

Formula:

(3-4)/4=-0.25

so I need a separate table box for positive values and separate table box for negative values based on above expresson

pleasehelp me out of this

Thanks,

Muthu

[#2]

Hi Anil ,

i have Opened New Discussion in that i have explained it clearly and i have also attached sample qvw and excel data

kindly visit and Help me out of it

How to separate one day of data from four days of data?

Thanks,

Muthu