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
