Monday, March 12, 2012

Pls Help If Statement

Hi All,
I have a query in formula.I created formula like this

IF {SALEEXP.EXPCODE}=144001966 THEN
{SALEEXP.AMOUNT}

it shows all the records from amount like this
ABDTI06000003 SMILE CARDS
24091700413 24091700413
404.42 0.00 0.00 0.00
0.00 45.33 0.00 0.00
0.00 0.00 -168.64 0.00
0.00 0.00 0.00
Pls help me to solve this problemPlease provide a sample of records you're running through this formula. Include headers to the columns of data.|||Hi Wenin,
It comes like this.

SALES Gujrat
Gujrat
Gujrat
Gujrat
Octrai Bill / Rounding Total
Vat Sale Vat Sale Vat Sale Vat Sale Cash





discount Off
12.5%
12.5%
4%
4%

Taxable Taxable Taxable Taxable
Sale Tax
Sale
Tax


ABDTI06000003 SMILE CARDS 0.00 0.00 0.00 0.00
[LST NO:24091700413][CST
NO:24091700413]

ABDTI06000003 SMILE CARDS 404.42 0.00 0.00
[LST NO:24091700413][CST
NO:24091700413]

ABDTI06000003 SMILE CARDS 0.00 -168.64 0.00
[LST NO:24091700413][CST
NO:24091700413]

ABDTI06000003 SMILE CARDS 0.00 45.33 0.00 0.00
[LST NO:24091700413][CST
NO:24091700413]|||Hi Wenin,
Pls see the attachment. It comes like this pls give me the solution|||It's not clear what the problem is.
Which one of the data items is the formula output, and what's wrong with the output? What are you expecting?

No comments:

Post a Comment