Hi Everyone,

Bear with me I am a newbie here.

I have an If function that returns both string and numeric result and the numeric result doesn't come up. See below:

Formula 1:  
if Left({SOP10201.SOPNUMBE},3)="INV" then "-na-" else "Days-"&({@Aged_to_Report_Date}-{@TransferAged})

My objective here is if the first condition is correct put "-na-" but if not show the numeric result.

The formula on it's own  is working but as soon as I put them in IF function the negative part (i.e., show the number) is not showing.

No errors of the IF formula when I click Check button.

Formula 2:
if Left({SOP10201.SOPNUMBE},3)="INV" then "-na-" else ({@Aged_to_Report_Date}-{@TransferAged})

If I modify forumula 1 as shown in formula 2 an error occurs when i try to save it...it says...A string is required here...

Both {@Aged_to_Report_Date}-{@TransferAged} are results of date calculations shown as numbers.

By the way I am using Crystal 8.5.

Please help.



Edited by Achilles - 15 Nov 2012 at 4:07pm