on 04-12-2018 12:14 PM
Hi,
I got a requirement, i would like to calculate in Crystal report 2016 following formula.But I am unable to write the syntax/formula for this.
% Qty = ( Total of Avialble Qty / total of target qty ) * 100
Kindly help me out, thanks in advance guru.
Regards,
Bharathi
Is this for a single record or for a set of records? If it's for a single record, you'll do something like this:
If {MyTable.TargetQty} <> 0 then {MyTable.AvailableQty} % {MyTable.TargetQty} else 0
There are a couple of things to note about this:
- The initial check for target qty > 0 prevents a divide by 0 error
- The "%" operator automatically does the divide then multiply by 100 to calculate a percentage.
If this is for a set of records, you'll use the "sum()" function. If you're looking for a grand total, you'll just pass the field to the function - sum({MyTable.MyField}). If you're looking for a subtotal based on a group in your report, you'll need to add the group field (which MUST match a group in your report!) - sum({MyTable.MyField}, {MyTable.GroupField}). So, your formula will look something like this:
If sum({MyTable.TargetQty}, {MyTable.GroupField}) > 0 then sum({MyTable.AvailableQty}, {MyTable.GroupField}) % sum({MyTable.TargetQty}, {MyTable.GroupField}) else 0
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.