Formula for counting Rows in the model

[former_member764680]

Is there a way in SAP Analytics Cloud to count the number of rows or records?

[OwenLiu]

Welcome and thanks for visiting SAP Community to get answers to your questions. While you're waiting for help, check out our tutorial to get started in SAP Community: https://developers.sap.com/tutorials/community-start.html, as it provides tips for preparing questions that draw responses from our members. The more details you provide, the more likely it is that members will be able to help you. Should you wish, you can revise your question by selecting Actions, then Edit. By adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile here: https://developers.sap.com/tutorials/community-profile.html

[nicolas_schell]

Hi,

where do you want to sum up? In the model or in the story?

If in the model, is a LiveConnection used?

In general, it always helps to add a Measure containing "1". This would be summed up later on.

Regards
Nico

[VijayetaSharma]

Hello jowdeefin,

If I am not mistaken, what you are looking for is "exception aggregation". Say number of documents posted in a given time period or number of PO's created etc. Check the exception aggregation explanation in below article.

Applying Aggregation in SAP Analytics Cloud

If you find shared info helpful, dont forget 🙂 to accept (accept button below this response) and vote (voting arrows on left side).

Thanks,

Vijayeta

[former_member764680]

Thanks. This also worked.