PA Reports for non empty/total %

[Poorva Bhawsar]

Hi Community,

I have to create few PA reports where i have some formulas involved for example i want to get the %age of active POs in my custom table.

So, first i want to get the count of non empty active POs and then i need to get the total number of active POs and need to calculate percentage based on it.

For the first automated indicator which is to get the count of non empty active POs, there i have added an additional condition as active POs is not empty.

For the second automated indicator which is to get the total number of active POs, i havent added any additional condition.

Do, i need to add any condition in the second automated indicator to get the total number of active POs or do i need to add any condition in the indicator source?

Thanks,

Poorva Bhawsar

[Mark Manders]

It depends on your setup. If your indicator source is only getting the active PO's, your second indicator can just run without any conditions. If you are getting all PO's from the source, you will need to put active=true on both indicators as well. 
But it depends on your source and reporting requirements. (if you need to report on all, you can also just have your indicator source get all and your indicators select the active ones.

[Poorva Bhawsar]

This is a custom table, so i dont have any active field over here as its not an extended table from task table.

What i did so far is, i havent added any condition in indicator source, i have just added it in my first automated indicator which is showing the count of non empty active POs as active POs is not empty and in my second automated indicator which is just showing the total count of active POs doesnt have any condition in it as it includes empty and non empty both records in it.

So, am i doing correct or going in the right way or not.

[AndersBGS]

Hi @Poorva Bhawsar ,

In general no, but as @Mark Manders also have said, it depends on how your data is structured etc. In general, I would just create on single indicator source with two different automated indicators. On one of the automated indicators I would add the condition "PO is not empty". 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Poorva Bhawsar]

Thank you for your quick response Anders. i did same. I havent added any condition in 2nd automated indicator which is just showing the total count of active POs which includes empty and non empty both.