Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009

    Red face Unanswered: formula in Crystal Report 8

    hi all,

    sorry, if my thread in wrong place

    i have 1 formula in my CR 8 like this

    if left(ToText({tbsubledger.subledgerdate}),4)=ToText({tblpercentage.percentyear}) then {tblpercentage.percent}
    result from formula above will be suffixed with "ADM's EXPENCES". Formula work fine if I run report from 1/1/2007 - 31/12/2007 ( 1 year ),

    but if I run report from 1/1/2007 - 31/12/2008 ( 2 year) or above, formula return me zero.
    it should be

    (percentage 2007 + percentage 2008) * ADM's EXPENCES
    how the best formula for my case in condition if I run my report for 2 year period or above??

  2. #2
    Join Date
    Jul 2007
    You say it works correctly if you run from 1/1/07 to 31/12/07, but does it work correctly if you run from 1/1/08 to 31/12/08?

    My approach would be to create a very simple report to show
    in 3 separate columns together with your formula in a 4th column and to look at the data and see if something is wrongly linked or if the data is somehow cancelling itself out (in particular look to see if there are any negative values as well as positive ones).


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts