Report Design: Nedd solution

Print Page | Close Window

Nedd solution

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14352
Printed Date: 28 Apr 2024 at 10:52pm

Topic: Nedd solution

Posted By: aarti
Subject: Nedd solution
Date Posted: 13 Sep 2011 at 11:21pm

HI i m trying to create a fomula as mentioned below

and getting error A running total cannot refer to a print time formula

if tonumber({LEV_PUB_OFF_SES_ALL.CUSTOM1})>0

then

{LEV_PUB_OFF_SES_ALL.CUSTOM1}/sum( mailto:%7b@TotalConfirmedApproved - {@TotalConfirmedApproved })

where

TotalConfirmedApproved contains following formula:

if({TPV_PUB_BASE_ORDER_ITEMS.APPROVED_STATUS}=200 and {TPV_PUB_LOV_REGN_STATUS.CODE}='100')
then
1
Else
0

please help ASAP

Replies:

Posted By: leatherbag
Date Posted: 14 Sep 2011 at 4:46am

sum( mailto:%7b@TotalConfirmedApproved - {@TotalConfirmedApproved })
what are you summing with this...... please explain
what if the sum is 0

Print Page | Close Window