Formula

[deepakqlikview_123]

Hi All,

I have used rangesum function previously as per below

=RangeSum(Alt(Before([Total Analysis]), 0), count(CHASSIS_NUMBER))

It was working fine.

But now I have calculated percentage by using below formula.

=Num((( sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)

        -

        sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT))

        /

        sum ({<DeptFlag={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE)),'#,#0%' )

Can you please suggest hoe to use rangesum function in above formula.

Thanks

[deepakqlikview_123]

Hi Manish,

As  per requirement I need to show result as

day2 data=Day1 data+day 2 data

day3 data=Day1 data+day 2 data +day 3data

day4data=Day1 data+day 2 data +day 3data+day 4data

As per column in above QVW file for data whatever we have calculated by using above formula.

By using above expression for rangesum not getting excepted result

Thanks

[MK_QSL · Accepted solution]

NUM((RangeSum(Above(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),0,RowNo()))

-

RangeSum(Above(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT),0,RowNo())))

/

RangeSum(Above(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),0,RowNo())),'#,#0%)

or

NUM((RangeSum(Before(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),0,RowNo()))

-

RangeSum(Before(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}PRESENT),0,RowNo())))

/

RangeSum(Before(sum ({<SHORT_NAME={'FAB'},Flag = {'3-4 Wheeler'}>}MAN_ON_ROLE),0,RowNo())),'#,#0%')

[deepakqlikview_123]

Its working