• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.