Skip to Content

12 months Trend Formula

Hi,

Can you please advise me to create the formula. I need to calculate the 12 months Trend formula for my chart.

The requirement is

For Example

Table A (1st Month) Table B (2nd Month) Table C(3rd Month)

Review Rev# Review Rev# Review Rev#

AAA 10 AAA 10 AAA 10

DDD 20 DDD 20 DDD 20

XXX 10 XXX 10 XXX 10

I need to calculate Average # of Reviews.

If the user runs the report for one month then the calculation would be

for AAA the formula would be = 10 /40 (Table[A] AAA+ Table[A] DDD+ Table[A] XXX)

for DDD the formula would be = 20 /40 (Table[A] AAA+ Table[A] DDD+ Table[A] XXX)

If the user runs the report for two month then the calculation would be

AAA 10 + AAA 10 = 20 /80

DDD 20 + DDD 20 = 40/80

If the user runs for the 3 months then the calculation would be.

AAA 10 + AAA 10 + AAA 10 =30 / 120

DDD 20 + DDD 20 + DDD 20 =60 / 120

The Report runs based on the Element Linking if the user clicks AAA for the 1st Month then the Chart should change as per the blow formula.

AAA 10 + AAA 10 = 20 /80

If the user clicks DDD for the 1st Month then the Chart should change as per the blow formula.

DDD 20 + DDD 20 = 40/80

Please help me to write the Formula

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 02, 2017 at 08:54 AM

    you could do something like:

    1. create input ready input control based upon variable="1" (user can change from 1-12)
    2. create a measurevariable: if variable = "1" Then your calculation for one month elseif variable = "2" then your calculation for 2 months ...
    3. create a variable:firstmonth =[Month] and make sure your you add the variable in the dependencies so you are able to fetch the fileter
    4. create per calculation per month (step 2) a formula setting the calculation dependending on the firstmonth
    Add comment
    10|10000 characters needed characters exceeded