Forum Discussion

Junaid11's avatar
Junaid11
Helper V
4 years ago

Progress based on two dates

Hello, I have a table for course start date and course completion. I want to get progress in % to see how much progress have been made. Like if it started in January and was to complete in December ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Junaid11 

 

I don't quite understand the expected result. What do you mean by "the progress should be accumulative"? Do you want to have a progress value for every course?

 

And when you want to slice it monthly, quarterly or yearly, we need to specify a date to represent the month/quarter/year. You want to use the first date or the last date or other dates in that period? When selecting different dates to calculate the progress %, the results would be different. Can you give an example that which result is you expect?

 

Best Regards,
Community Support Team _ Jing