Cummulative Supplier Count

[Anonymous]

Hi All,

I am trying to calculate cumulative supplier count by using the below expression with an "if "condition in it .But Im getting an error can anyone help me ,

=RangeSum(above(count(distinct if(vSpendType = 'Sourceable', (if(is_sourceable = 'Y', amount))

, if(vSpendType = 'SC Manageable', (if(is_sc_manageable = 'Y', amount))

  ,Supplier))),0,rowno()))

TIA.

digvijay‌

[MK_QSL]

Don't know what exactly you are doing in this expression but I can suggest something like below.

=RangeSum(Above(Count(Distinct If(vSpendType = 'Sourceable' and is_sourceable = 'Y', amount,If(vSpendType = 'SC Manageable' and is_sc_manageable = 'Y', amount,Supplier))),0,RowNo()))