Value to print only if statement is true (PLD)

[Former Member]

Experts,

I have a client who want to print certian Batch information that is related to a Item Group.

If Item group is A, then the pH UDF must print.

If Item group is B, then the Moisture UDF must print.

I have created these UDF's on the Batch screen, and was able to get them to print inthe Delivery Batch Details. But as they have quite a lot of UDF's I need to limit what print by Item group. This is unique to item group.

Is there a way in PLD to specify that if this Item is in Group A, print these fields?

Anhy help would be appreciated.

Marli

[Former Member · Accepted solution]

Hello ..

In PLD is this possible, first of all need to have the Rule Group field. Then you would have to create as many fields formula to create the conditions and amount of these exist.

His field formula would be something like that ...

(Field_100 == '100 '), where Field_100 correspond to the field which brings the Group of article and the code equals 100

Then you link all those fields that should appear in this field formula. If the condition is met fields appear.

Hope this helps

Yours sincerely,

[Former Member · Accepted solution]

Paul and Gordon,

Thanks for your answers, I understand what you want me to do, but am unsure of how to formulate the conditions.

Here is what I'm testing:

I have a formula field F_064: This should print database field F_084 if the Item Group is '106'. If the Item group is '103' it should print database field F_085.

The Item Group is displayed in Field F_065.

Can you can help me with what I need to put in the Formula field?

Regards,

Marli

Edited by: Marli Schutte on Sep 20, 2010 11:28 PM

[Former Member · Accepted solution]

You need:

1. Create 2 formula fields F_065=='106' & F_065=='103' (If you have more groups, you need mote)

2. Link F_084 to the 1st field and F_085 to the 2nd.

3. Put F_084 & F_085 in the same place

[Former Member · Accepted solution]

Gordon,

Thanks, I did what you said (Created the second formula field as F_086).

This prints out the fields that I want to print, when the Item group is something specific, but the values it prints is 1, not the value in the UDF (F_084, F_085). I have checked with a query that the values stored in the UDF's are not 1.

Thanks,

Marli

[Former Member · Accepted solution]

If I understand you correctly, you put 1st formula in F_064 and 2nd in F_086. Is that right? One of these two field must be 1 when the group is either '103' or '106'. Both fields need to be hidden.

[Former Member · Accepted solution]

Gordon,

Yes, you are right about the setup adn how this behaves.

But, I do not want the value 1 to be brought back when there is something in that field, I want the value in the field (F_084, F_085) to be brought back.

Thanks for your help.

Marli

[Former Member · Accepted solution]

F_084 & F_085 will be displayed automatically if you link them correctly to F_064 & F_086.

[Former Member · Accepted solution]

Gordon,

Here is how I linked them:

Item Group field: F_065, linked to nothing

Variable field 1: F_064, formula: (F_065== 106), linked to nothing

Variable field 2: F_086, formula: (F_065==103), linked to nothing

UDF field 1: F_084, linked to F_064

UDF field 2: F_085, lnked to F_086

I still get the value 1 back on this configuration. I want the values in the UDF1 and UDF 2 to display.

Thank you for your help.

Marli

[Former Member · Accepted solution]

Have you hidden F_064 and F_086?

[Former Member · Accepted solution]

Gordon,

No, I have not hidden these fields. They are the ones displaying the value 1 according to which Item group the item is in the line.

Thanks,

Marli

[Former Member · Accepted solution]

They must be hidden.

[Former Member · Accepted solution]

Gordon,

I have made these not visable in the Properties field, and now the values 1 is not displaying. The real values are also not displaying.

Seems like we are missing something in the communication. I'll start a new example and try again.

Thanks,

Marli

[Former Member · Accepted solution]

F_084 & F_085 are the fields to display at the same spot on top of each other.

[Former Member · Accepted solution]

Gordon,

Thanks so much!

In order to see what is happening I placed all these fields next to each other. When I placed them on top of each other it displayed correctly.

Marli

[Former Member]

Marli,

If you have only 2 or very few item groups and UDF to print, you may use conditional formula. Otherwise, no.

Thanks,

Gordon