Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Crystal and .csv table linking

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Katfra
Advanced Member
Posts: 30
Advanced Member
12/5/2011 3:19 PM
    I've linked a .csv file as my table in crystal. I have a debit, credit, and difference colum in the file which shows in the crystal report, except where anything has a negative value. I've tried creating calculted fields to produce the credit balance in crystal, which worked in my credit column. However, if I create a formula Debit-Credit where my debit might be a zero balance, my result is blank in the difference column. Anyone have any ideas? I've tried a running total as well with no luck.
    charliewilliam
    Basic Member
    Posts: 16
    Basic Member
    12/5/2011 3:39 PM
      Is your Debit-Credit truly zero or is it null? You may want to consider checking to see if the Debit or Credit is null first by using something like:
      IF IsNull(Debit) THEN 0 - Credit ELSE
      IF IsNull(Credit) THEN Debit - 0 ELSE
      Debit-Credit
      Katfra
      Advanced Member
      Posts: 30
      Advanced Member
      12/5/2011 7:40 PM
        That worked, thank you. Now new problem seems to be that i have invoice pulling over from my .csv file that have different values in Crystal when compared to the .csv file.