How to Seperate Positive and Negative Average ?

[#1]

Hi All,

I have a table like below

The Average is been Calculated based on Below formula:

Formula:

(Toady- Previous day)/Previous day

From Above table, I need an Output Like Below tables. I Need to Separate  Top  Positive(Descending Order) and  Top 10 Negative (Descending Order)Values from above table for Three Days (04/09/2017 PM,04/08/2017 PM,04/07/2017 PM)

Expected  Output:

For (04/09/2017 PM):

Positive:

TGB Name	Date	Average
Metro_AMI	4/9/2017 PM	0.50

Negative;

TGB Name	Date	Average
Bala_AMI	4/9/2017 PM	-0.78
Cheta_AMI	4/9/2017 PM	-0.85

For (04/08/2017 PM):

Positive:

TGB Name	Date	Average
Bala_AMI	4/8/2017 PM	0.80
Metro_AMI	4/8/2017 PM	0.33

Negative:

TGB Name	Date	Average
Cheta_AMI	4/8/2017 PM	-0.13

For (04/07/2017 PM):

Positive:   

TGB Name	Date	Average
Cheta_AMI	4/7/2017 PM	1.14
Metro_AMI	4/7/2017 PM	1
Bala_AMI	4/7/2017 PM	0.25

Negative:

For 04/07/2017 PM there is no Negative Average

Please find the attached QVW and Data Excel for your reference and kindly help me out of this

Thanks

Muthu

[Anil_Babu_Samineni]

Like this?

[avinashelite]

try like this

Positive :

if(sign(Expression)=1,Expression)

Negative:

if(sign(Expression)=-1,Expression)

[#4]

what table ? Can you please tell me the name Of the table?

Give me example for data.

[#5]

Kindly use formula in enable conditional formula in

Actual table +Ve:

(Toady- Previous day)/Previous day >= 0

Actual table +Ve:

(Toady- Previous day)/Previous day <= 0