report writer calculated field

(0) Share

Report

Posted on by Community Member

Hello,

I am fairly new with report writer and looking for some tips on creating a calculated field. I am trying to modify a check remittance form. I have some text to print on the form where if the Vendor Class is ABC, the text should print "submit payment to Address 1". However, if the Vendor Class is any other value, the text should print "submit payment to Address B". Any tips or guidance to create this would be greatly appreciated.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

The conditional calculated field should be something as shown below:

In the case above, I am saying,

If "Test = 1

Then print "Submit Payment to Address 1"

Else Print "Submit Payment to Address B"

So, in your case, in the conditional field, you should include

IF Vendor Class = "ABC"

Then print "Submit Payment to Address 1"

Else Print "Submit Payment to Address B"

Once you're done with the conditions, give this field a name and throw in to the report specific body part.

Let us know if you have any further inquiries,

Was this reply helpful? Yes No