Business Activity Query

Yahoo Archive
21
Here is an example of an If statement formula that would work in a Baq.
IF Sum ({jobmtl.requiredqty}, {joboper.shortchar01})<> 0 THEN (Sum
({jobmtl.requiredqty}, {joboper.shortchar01})- Sum ({@Actual Used},
{joboper.shortchar01}))/Sum ({jobmtl.requiredqty}, {joboper.shortchar01})*100
ELSE 0
Mike
mbrown@...



________________________________
From: Karen Schoenung <kschoenung@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thu, May 12, 2011 3:15:23 PM
Subject: [Vantage] RE: Business Activity Query


In a calculated field - yes

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ellen Lensing
Sent: Thursday, May 12, 2011 3:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Query

Can a if statement formula be put in a BAQ??

Middle West Manufacturing Corp.

Ellen Lensing

Accounting Manager

Phone 262-251-8760

Fax 262-251-8769

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]