You need to sign in to do that
Don't have an account?
Asakti
conversion report
In Account object i have one status picklist which has 3 value blank,client,prospect ,i want to create the report with conversion rate between only client and prospect type
example:
If there are 78 prospect came in last month and 1 is only client then
(1/78)*100= 1.28
i want to show 1.28.
What i have done till now:
Report on Account and filter last month,then group by status Field.
and adde the below formula field.
RowCount/PARENTGROUPVAL(RowCount, Account.Status_Of_Account__c)
it is not working.
example:
If there are 78 prospect came in last month and 1 is only client then
(1/78)*100= 1.28
i want to show 1.28.
What i have done till now:
Report on Account and filter last month,then group by status Field.
and adde the below formula field.
RowCount/PARENTGROUPVAL(RowCount, Account.Status_Of_Account__c)
it is not working.