Business Objects

[choco_fudge]

hi,
i need some help from people who know about business objects but this not really concerns about VB. i have this formula statement : = If (IsNull(Sum(<Amount (S$) (Lic) (CurrentFY)> Where(<Licence type key (Lic)> = "FA")))) Then 0 Else Sum(<Amount (S$) (Lic)> Where(<Licence type key (Lic)> = "FA"))

this statement will O if is null. What i want to display is a "-" <-- a dash instead of 0. But i faced problem in doin this.

if i put :
If (IsNull(Sum(<Amount (S$) (Lic) (CurrentFY)> Where(<Licence type key (Lic)> = "FA")))) Then "-" Else Sum(<Amount (S$) (Lic)> Where(<Licence type key (Lic)> = "FA"))
It will prompt me "incorrect data type"

if i put :
If (IsNull(Sum(<Amount (S$) (Lic) (CurrentFY)> Where(<Licence type key (Lic)> = "FA")))) Then - Else Sum(<Amount (S$) (Lic)> Where(<Licence type key (Lic)> = "FA"))
It will prompt me "syntax error"

can anyone help me with this? thanks a lot!

[Edneeis]

What is this in or for or whatever? Try:
IIF(If (IsNull(Sum(<Amount (S$) (Lic) (CurrentFY)> Where(<Licence type key (Lic)> = "FA")))) Then 0 Else Sum(<Amount (S$) (Lic)> Where(<Licence type key (Lic)> = "FA"))=0,"-",If (IsNull(Sum(<Amount (S$) (Lic) (CurrentFY)> Where(<Licence type key (Lic)> = "FA")))) Then 0 Else Sum(<Amount (S$) (Lic)> Where(<Licence type key (Lic)> = "FA")))

But it seems that whatever is using this statement is looking to get an integer back and you are trying to switch it to a string which is what it doesn't like. The problem should be fixed there.