Calculation Using If Condition

Stimulsoft Reports.WEB discussion
Post Reply
omkar.patange
Posts: 22
Joined: Wed Dec 05, 2018 12:01 am

Calculation Using If Condition

Post by omkar.patange »

How to calculate ?

If the taxes are application, need to do calculation 5% If Not No.


{IFF(Info.GST_Applicable_ == "Yes", "(double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental) + double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental)* 0.05)", "(double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental) + double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental)))}

This is not working.
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: Calculation Using If Condition

Post by Lech Kulikowski »

Hello,

Please check the following expression:
{IIF(Info.GST_Applicable_ == "Yes",
(double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental) + double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental))* 0.05,
(double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental) + double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental)))}

Thank you.
omkar.patange
Posts: 22
Joined: Wed Dec 05, 2018 12:01 am

Re: Calculation Using If Condition

Post by omkar.patange »

Lech Kulikowski wrote: Thu May 16, 2019 9:23 am Hello,

Please check the following expression:
{IIF(Info.GST_Applicable_ == "Yes",
(double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental) + double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental))* 0.05,
(double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental) + double.Parse(Info.Sale_Price) - double.Parse(Info.Applied_Rental)))}

Thank you.


Yes, this is working for yes. What if GST is not applicable you to write in the same formulae is its "NO". Thank you
Lech Kulikowski
Posts: 6245
Joined: Tue Mar 20, 2018 5:34 am

Re: Calculation Using If Condition

Post by Lech Kulikowski »

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
Post Reply