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

[MK_QSL]

Not getting your question properly. Could you please elaborate little more !

[deepakqlikview_123]

Hi Manish,

As per requirement I want to apply rangsum function for percentage whatever calculated in below mentioned 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%' )

Thanks

[MK_QSL]

Not sure below will work on not... but nothing wrong in trying...

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

-

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

/

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

'#,#0%' )

[deepakqlikview_123]

Hi Manish,

It is not showing excepted results.

Thanks.

[MK_QSL]

If possible, please provide sample data in excel file along with your requirements.

only 5-10 like would be ok to work.

[deepakqlikview_123]

Hi Manish,

Please find attached QVW file contains sample data.

Please suggest how to use Rangesum function in above formula.

Thanks,

[MK_QSL]

There is no DeptFlag in your data model.

use below

=num(

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

  -

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

/

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

[deepakqlikview_123]

HI manish,

How to use rangesum function in above formula.

Thanks

[MK_QSL]

NUM(

          (

               RangeSum(YourFirstExpression)

               -

               RangeSum(YourSecondExpression)

          )

               /RangeSum(YourFirstExpression),

'#,##0.00%')