Skip to Content
0
Former Member
Apr 13, 2010 at 07:41 PM

Shared Variable in summary formula

209 Views

Hi All,

I would appreciate any help I can get on this.

I have a subreport that retrieves a Foriegn Exchange rate for a specific date ( main report & sub-report are linked by date). I have no problem passing the value to the main report but when I use that value in a summarized formula field (@Princip Rem Term) I get the following error "A summary field has been specified on a non-recurring field Details: @Princip Rem Term"

Here are my formulas

Sub-report:

@FX rate

Shared numbervar FX;

FX := TONUMBER({ZFI_EXCHANGE_RATE.MRATE})

Main report:

@FX Rate

shared numbervar FX;

@PrincipalCAD

if {ZFI_TREASURY.VTBFHAPO-WZBETR} = "USD" then

{ZFI_TREASURY.VTBFHAPO-BZBETR} * {@FX Rate} else

{ZFI_TREASURY.VTBFHAPO-BZBETR}

@Principal Rem Term

{@PrincipalCAD}*({ZFI_TREASURY.VTBFHAZU-DELFZ}-{@AsofDate})

Is there a way to solve this problem? Can't I use the value I retrieved from the sub-report as a staic vlaue and summarize it??

Thanks for help...very much appreciated!!

Romeo