Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Scenario for count growth% which having negative values

Hi Experts,

  i want a formula for count,below i explain the scenario,

Cust FieldCal yr/mon FieldGrowth %
13138304.2013-100
13138304.201378
13138304.201399
13138304.201319
13138304.201373
13138304.201354
13138304.201487
13138305.201323
13138305.201434
13138306.201345
13138306.201467
13138307.201378
13138307.201434
13138308.201323
13138308.201434
13138309.201367
13138309.201434
13138310.201334
13138310.201334
13138310.201445
13138311.2013-34
13138311.2014-45
13138312.2013-56
13138312.2014-65
13138301.2014-23

i want to count growth% of only current cal/yr month(04.2014 to 12.2014) which having negative values except 01.2014 for all customers.please

help me in this regard....

Result should come like

Cust          Count

---------------------------------

131383          2

Thanks.

Ashwin

Former Member
Not what you were looking for? View more on this topic or Ask a question