If Statement in PLD

[Former Member]

Hi

How can I do an If statment in PLD.

For Example:

If field_xxx <0 then show 0 otherwies field_xxxx

Thanks

[Former Member · Accepted solution]

There is no IF statement in PLD, you have to use multiple fields to represent one IF. It called conditional formula. Check other threads discussing it and you will know more.

Thanks,

Gordon

[YatseaLi · Accepted solution]

Also you can implement it this way:

1.Add an addintional UDF for if /else result

2.Add a format search with Query (if...) to the UDF above.

3.Use the UDF in the report.

Either if you are B version, you also can implement the complex conditional with tax engine...

Regards,Yatsea

[former_member903986 · Accepted solution]

I want to segregate the amounts of items i.e labour and parts , how "if condition" can be created if condition are based on item codes,

here is an example,

make sum of line total if "inv1.itemcode" like 'srv%'

i have create a formula field with formula, F_##=='srv%'  to select only labor items then create another formula field of colsum("F_##") and link both the fields but still its not working

*here ## represent field number

kindly guide

warm regards

aamir