Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

How to do rangesum with division

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.

JuneJulyAugustSeptemberOctoberNovemberDecember
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

Labels (2)
11 Replies
kavita25
Partner - Specialist
Partner - Specialist
Author

Yes. Its not working as expected. 😐

Regards,

Kavita

sunny_talwar

Difficult to know your setup. Unless you can share a sample where we can see the issue, it would be difficult to know what you are running into.