Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Details Return true

Hello guys,

I am still a newbie in crystal report and trying to learn from the existing reports for SAP in our company. Recently, I am trying to edit our sales invoice for getting the right computation.

So I got this result.

What I wanted to have is, when the condition for Vatgrp = 'TRUE' then I will get the summary of the stocksum that returns true on vatgrp.

ex:

Description: crabstick surimi 33% 8cm L VP 10x500gms

1,237.50 must be the result for the total sale(vat inclusive) since vatgrp = 'TRUE'

Is is possible to get it without making effect on details? I want stocksum to be placed on the report footer particularly on TOTAL SALE(Vat inclusive). Thank you so much for your help.

Regards,

JZA

Tags:
Former Member
replied

Hi Ramoncito,

Yes, just create a formula with this code:

If vatgrp = "True" then

     {StockSum}

Then, go to the 'Insert Summary' option > Select the formula field above from the 'Field to Summarize' drop-down > Choose 'Sum' as the Summary > Place the summary on the Report Footer (Grand Total).

-Abhilash

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question