BAQ Null Value Blank Title 80851

No, I am not summarising any table I just want to see the invoice value per month but also want to see the individual invoices and sales order these invoices belongs to, thats why I piicked up the invoice detail table, I can show individual values of ExtPrice, discount, Total Misc Charge, AdvanceBill Credt and Tax Amount, but now I want add them all to get the total value per invoice detail but where there is no tax, it is giving me an error, so I was trying to convert the tax amount in a calculated field to say that if tax is null then 0 else tax amount. but it doesnt work due to the null value.

Second thing is I dont want to convert it into crystal as the beauty of dashboard is that you can go to the actual record by just right clicking the relevant number which obviously you cant do on crystal report.

any other suggestion would be much appriciated. thanks



--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Ahh, true. Sorry. I'm only on my first cup of coffee.
>
> Are you summarizing the table to get your value?
>
> Are you dumping this to Crystal Reports? If so, it is more easily
> do-able in Crystal Reports......
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of emailrashidforum
> Sent: Monday, July 27, 2009 9:17 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ Null Value
>
> This thing works for character field but for the number (UD Fields) it
> doesnt work as number fields are always have a 0.00 value so they are
> not null. any other suggestion please. thanks
>
>
> --- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@> wrote:
> >
> > Compare the BAQ field to another field you always know will be NULL,
> for
> > example Number20 (UD field).
> >
> > Then you can use an If/Then statement in a Calculated field.
> >
> > Something like this:
> >
> > If YourTable.YourColumn = YourTable.Number20 then 0 else
> > YourTable.YourColumn
> >
> >
> >
> >
> > Vic
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of emailrashidforum
> > Sent: Monday, July 27, 2009 7:55 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] BAQ Null Value
> >
> > Is there a way to convert the null value to zero in a BAQ. I am trying
> > to calculate the total amount in invoice Detail, it works if there is
> a
> > tax against this invoice detail but it there is no tax against this
> > invoice detail then it doesnt calculate. any suggestions? Thnanks
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access.
> )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
Is there a way to convert the null value to zero in a BAQ. I am trying to calculate the total amount in invoice Detail, it works if there is a tax against this invoice detail but it there is no tax against this invoice detail then it doesnt calculate. any suggestions? Thnanks
Compare the BAQ field to another field you always know will be NULL, for
example Number20 (UD field).

Then you can use an If/Then statement in a Calculated field.

Something like this:

If YourTable.YourColumn = YourTable.Number20 then 0 else
YourTable.YourColumn




Vic


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of emailrashidforum
Sent: Monday, July 27, 2009 7:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Null Value

Is there a way to convert the null value to zero in a BAQ. I am trying
to calculate the total amount in invoice Detail, it works if there is a
tax against this invoice detail but it there is no tax against this
invoice detail then it doesnt calculate. any suggestions? Thnanks



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
This thing works for character field but for the number (UD Fields) it doesnt work as number fields are always have a 0.00 value so they are not null. any other suggestion please. thanks


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Compare the BAQ field to another field you always know will be NULL, for
> example Number20 (UD field).
>
> Then you can use an If/Then statement in a Calculated field.
>
> Something like this:
>
> If YourTable.YourColumn = YourTable.Number20 then 0 else
> YourTable.YourColumn
>
>
>
>
> Vic
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of emailrashidforum
> Sent: Monday, July 27, 2009 7:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ Null Value
>
> Is there a way to convert the null value to zero in a BAQ. I am trying
> to calculate the total amount in invoice Detail, it works if there is a
> tax against this invoice detail but it there is no tax against this
> invoice detail then it doesnt calculate. any suggestions? Thnanks
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
Ahh, true. Sorry. I'm only on my first cup of coffee.

Are you summarizing the table to get your value?

Are you dumping this to Crystal Reports? If so, it is more easily
do-able in Crystal Reports......




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of emailrashidforum
Sent: Monday, July 27, 2009 9:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Null Value

This thing works for character field but for the number (UD Fields) it
doesnt work as number fields are always have a 0.00 value so they are
not null. any other suggestion please. thanks


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Compare the BAQ field to another field you always know will be NULL,
for
> example Number20 (UD field).
>
> Then you can use an If/Then statement in a Calculated field.
>
> Something like this:
>
> If YourTable.YourColumn = YourTable.Number20 then 0 else
> YourTable.YourColumn
>
>
>
>
> Vic
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of emailrashidforum
> Sent: Monday, July 27, 2009 7:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ Null Value
>
> Is there a way to convert the null value to zero in a BAQ. I am trying
> to calculate the total amount in invoice Detail, it works if there is
a
> tax against this invoice detail but it there is no tax against this
> invoice detail then it doesnt calculate. any suggestions? Thnanks
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access.
)
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
vantage@yahoogroups.com wrote:
> This thing works for character field but for the number (UD
> Fields) it doesnt work as number fields are always have a
> 0.00 value so they are not null. any other suggestion please. thanks
>
> --- In vantage@yahoogroups.com
> <mailto:vantage%40yahoogroups.com> , "Vic Drecchio"
> <vic.drecchio@...> wrote:
>>
>> Compare the BAQ field to another field you always know will be NULL,
>> for example Number20 (UD field).
>>
>> Then you can use an If/Then statement in a Calculated field.
>>
>> Something like this:
>>
>> If YourTable.YourColumn = YourTable.Number20 then 0 else
>> YourTable.YourColumn
>>

This thread may give you some ideas:
http://tech.groups.yahoo.com/group/vantage/message/66601


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4281 (20090727) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com