calculating Ratio on conditional level

[#1]

Hi All,

We have data to the granularity of Week level .

we have a requirement where

if value of A is less then value B for that week then we need to add achieve= achieve +1 for that week .considering achieve as 0

and in final output we need to show achieve/52 . total count of achieve by number of weeks in year .

This needs to be shown at YTD , mtd and month and week level .

How can I achieve this requirement .

Do we need to do calculation in script or can we handle it in frontend

Thanks

[Kushal_Chawda]

Please share the sample file with required ouptput

[#3]

Hi Kush ,

thanks for the reply .

So here it goes .

We have some target define at weekly level.

These target are  performed .

if the target performed is greater then the target given we consider it as a more then expected . and assign it value 1 for that week  otherwise 0

so in total it would be 52 weeks in an year .

we need to calculate the total expected and then divide it by 52. that would be the expected output .

I will try to upload a sample file

thanks