syntax logic

[EBee]

if {MB_View.Ad_Type} = 'C' and {MB_VIEW.Account_Type} = 'C'
or {MB_View.Ad_Type} = 'C' and {MB_VIEW.Account_Type} = 'G'
or {MB_View.Ad_Type} = 'L' and {MB_VIEW.Account_Type} = 'C'
or {MB_View.Ad_Type} = 'L' and {MB_VIEW.Account_Type} = 'G'
or {MB_View.Ad_Type} = 'L' and {MB_VIEW.Account_Type} = 'V'
or {MB_View.Ad_Type} = 'N' and {MB_VIEW.Account_Type} = 'C'
or {MB_View.Ad_Type} = 'N' and {MB_VIEW.Account_Type} = 'G'
// parameter period
and {MB_VIEW.Period} <= {?Period}
// compares period year to current year
and year({MB_VIEW.Insert_Date}) = year (CurrentDate)-1 then
//Revenue calculation
{MB_VIEW.Insert_Cost} - {MB_VIEW.Insert_Discount}


The formula YTD current revenue runs but I think the first part is not right. the way I wanted this to calculate is to total all revenue from period 1 to (?Period) ( the periods data are from 1 -12)

However, my report is not comming with the same amount with the current revenue

what 'em I doing wrong here, i appreciate any suggestions

thanks
erwin

 

[synapsevampire]

This:

// compares period year to current year
and year({MB_VIEW.Insert_Date}) = year (CurrentDate)-1 then

Says take the previous year (you use -1), not the current period year.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com