Calculation Using If Condition

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

Calculation Using If Condition

Post by omkar.patange » Wed May 15, 2019 4:27 pm

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: 1305
Joined: Tue Mar 20, 2018 5:34 am

Re: Calculation Using If Condition

Post by Lech Kulikowski » 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.
omkar.patange
Posts: 4
Joined: Wed Dec 05, 2018 12:01 am

Re: Calculation Using If Condition

Post by omkar.patange » Thu May 16, 2019 9:37 pm

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: 1305
Joined: Tue Mar 20, 2018 5:34 am

Re: Calculation Using If Condition

Post by Lech Kulikowski » Fri May 17, 2019 7:10 pm

Hello

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

Thank you.
Post Reply