Hello All,
I have following scenario of grouping one of Crystal report (SAP Crystal for Enterprise)
I want to calculate ‘EARNING BEFORE TAX’ at report footer which Sum of all the earnings (i.e. Group 3 values) Minus Total Taxation.
I mean EARNING BEFORE TAX=NET EARNING – Total Taxation.
Could you please help me with the formula for the same.
Current I’h just used running total and kept it at the Report Footer which is summing up everything (Similar to NET EARNING).
Thanks in advance.
Use a formula which excludes tax eg
If type NOT( in [Taxation, Withholdingtax]) then value field else 0
replace fields and descriptions as appropriate for your report, use this in your Running total.
Ian
When use this formula 'type' got red underline and error says
"A number, currency, date etc. is expected here"
I wrote below formula
If type NOT( in ['Taxation', 'With-Holding Tax']) then {@Balance Ledger} else 0
Also these are not the only 2 groups in the report. There are around 15-20 groups.
Replace Type with your field which defines the descriptions 'Taxation', 'With-Holding Tax'.
These are setting those values to zero for your running Total if there are other types that should be excluded you will need to add them to list.
Ian
Thanks Ian,
I'm still facing 2 issues in this.
1) I used below formula
If GroupName ({ECC_IFSC_PRD_UNI.IFSC Infoset for Reporting\Account Number}) NOT (in['Taxation']) then {@Balance Ledger} else 0
here NOT is red underlined and error msg is saying 'then' is expected here.
2) this formula is not available in drop down when I'm trying to create running total on it.
Thanks.
You cannot use a groupname in this formula if you want to do a summary or RT on it.
Try
If NOT({ECC_IFSC_PRD_UNI.IFSC Infoset for Reporting\Account Number} in ['Taxation']) then {@Balance Ledger} else 0
This assumes @BalanceLedger does not contain any summaries too
Ian