Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Target data from Jan to Dec 2020 where Jun 2020 target is 50%.
I want to calculate the % starting from Jun
July is Jun+(50%/3)= 66.67%, Aug is 66.67%(July)+(50%/3)=83.33% and so on.
June | July | August | September | October | November | December |
50% | 66.67% | 83.33% | 100% | 100% | 100% | 100% |
Please help me with the solution.
Thanks in Advance.
@sunny_talwar @Anil_Babu_Samineni
Regards,
Kavita
Do you already have 50% for June in your data? Do you have 0% for July or do you have another value in the database? And how do you get 50% + 50%/3 for July?
Yes I already have Jun as 50%. and previous value with(50%/3) is fixed.
Thanks for your response.
Regards,
Kavita
"previous value with(50%/3) is fixed"
Not sure what this means?
Hello,
Please find the screenshot:
June is set as 50%.
July is June+(Fixed value(50%/3))=66.67%
Aug is July +(Fixed value(50%/3))=83.33%
Regards,
Kavita
Oh okay, 50% is not dependent on the fact that June is 50%. Even if June was 20%, you would still have added 50%/3 to it? Also, do you have value for Jan, Feb, Mar, Apr, May, Jun? or are those all 0?
Yes.. Jan to May is 0.
Regards,
Kavita
How about my other question? What if Jun's value was 20%? Would you still want Jul to be 20% + 50%/3?
Yes.
(20%)+(50%/3).
Regards,
Kavita.
I would do something like this
If(Month >= June, RangeSum(Sum(TOTAL Target), (Month - 6)*0.1666666, 0)
I have a feeling this won't work the way you want, but I still don't have enough details to be able to offer you more help.