|
-
Sep 1st, 2002, 08:38 PM
#1
Thread Starter
New Member
Business Objects
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|