The nested formulas are as follows:
{@MRP Amount w/zeros}=if IsNull({PK010033.MRPAMOUNT_I}) then 0 else {PK010033.MRPAMOUNT_I}
{@Qty Issued w/ Zeros} = if IsNull({PK010033.QTY_ISSUED_I})then 0 else {PK010033.QTY_ISSUED_I}
I'm not sure what else you need, these 3 values are all numeric for...
Thanks for the help, first of all my version of Crystal Reports is 9.0 Developer version. The problem is I'm wanting to select specific values out of a summarized field and for instance I want to filter my report to show all values that are not equal to zero in the below formula.
Sum ({@MRP...
Is this possible??? I have a summary created such as a sum for a group of values and I need to use the select expert to not pull the zero values. Help...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.