how to display total number of Subscription count in invoice

[amolp]

how to display total number of Subscription counts per account on invoice template with active subscription and inactive subscription counts separately 

[Rajkumar]

Hey Amol,

Like we discussed in our meeting, counting rows is not possible directly. But we can achieve this by below steps:

• Create a custom field in the account - Active Subscription
• Create a workflow in which it counts the number of active subscriptions under one particular Customer account and update the custom field
• Then you can make use of the custom field in the template to display active subscription numbers

Above is the same for inactive subscriptions as well. Hope my answer helps you.

Thanks,

Raj