How to use If condition in formula editor of PLD

[Former Member]

Hi freinds,

I am trying to get the Tax breakup inthe PLD of the Marketing document by using Formula fields.But while calculating VAT or CST percentage on BED+Cess system does not calculate exact value .It gives say 12.3896 when actually it should be 12.5 %.How do I get this figure using Round Off operation or Decimal operation?

Also I want to display VAT or CST giving some condition. For example if the above value(percentage) is 4 or 12.5 then a Text field VAT should be visible;if the value is 2 or 3 then a text field CST should be visible in the print. How do I get this?

please help.

[kvbalakumar]

You can't directly use the if statement, but indirectly you can achieve what you need.

Let's take Field_001 having the result of calculated Tax

i.e as per you Field_001=4 or 5 or 12.5

Create a formula field(Field_002) with the following formula

Field_001==4

The above formula will gives 1 if both fields equal otherwise 0

Create a Text field (Field_003) and type VAT and link

the text field to Field_002.

Now the text VAT will appear only the condition(in Field_002) satisfy.

I think it will solve your problem.

Try the above and still problem exists reply here.

Regards,

Bala

[Former Member]

Hi Bala,

Thank you very much for your reply.It helped a lot to solve my problem.

Sudhir

[kvbalakumar]

Try this formula

Round((Your formula),1) 

Regards,

Bala