What restrictions / conditions should set?

[Former Member]

Hi,

I have to create a report where I have to show all accounts for the customers that have at least an account with days greather than 0.

This is the default report:

Customer Account Amount Days

222222 25331 1000 9

222222 25231 800 0

222222 25831 1300 1

333333 25110 900 0

333333 29110 1100 0

444444 25110 800 0

444444 29110 900 1

555555 29110 1600 0

This is how the report should like:

Customer Account Amount Days

222222 25331 1000 9

222222 25231 800 0

222222 25831 1300 1

444444 25110 800 0

444444 29110 900 1

Do you know what restrictions/conditions should set?

Thanks,

Dragos

[Former Member]

I have set a condition on Days for value greater than 0 and in the Characteristic Assignment tab I choose for Individual Char. and Char Combinations the Customer characteristic and the problem was solved.

Thanks anyway for your help

[former_member189638]

Try creating a Calculated Key Figure. Just simply use your key Figure Account Days in that...Set the Calculate Single Value As as "Average of all values" and Exception Aggregartion on Customer.

Now create a condition on this Calucalted Key Figure > 0.

[Former Member]

Hi ,

You can try user exit variable to get your your requirement.

Harry

[Former Member]

Hi,

Is the Day a keyfigure, if yes, directly set a condition on Days for value greater than 0.

If days is a char or Numc, create a new formula, and in it a new formula varaible withthe day value populated with Replacement path. and on that formula keyfigure create a similar condition as mentioned above.

Hope this helps.

Regards,

Umesh.

[Former Member]

Yes, it is a key figure, but it doesn't work to put just a condition on Days greater than 0 because the report will show only the accounts with Days>0, not all the accounts for customers with at least one account with days > 0

If I put the condition days>0 the report will be:

Customer Account Amount Days

222222 25331 1000 9

222222 25831 1300 1

444444 29110 900 1

not:

Customer Account Amount Days

222222 25331 1000 9

222222 25231 800 0

222222 25831 1300 1

444444 25110 800 0

444444 29110 900 1

[Former Member]

Use condition daysgreater than or equal to zero.

Days>=0 then ity will show you result as per your requirement.

Regards,

Reddy

[sanjiv_mohta3]

Dragos,

You might want to look into using a Replacement Path variable on Customer. The Query input can be used to filter the list of customers with activity.

http://help.sap.com/saphelp_nw70/helpdata/en/2c/78a03c1178ad2ce10000000a114084/frameset.htm

Regards,

Sanjiv