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.
Calculation Using If Condition
-
- Posts: 22
- Joined: Wed Dec 05, 2018 12:01 am
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Calculation Using If Condition
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.
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.
-
- Posts: 22
- Joined: Wed Dec 05, 2018 12:01 am
Re: Calculation Using If Condition
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
-
- Posts: 6245
- Joined: Tue Mar 20, 2018 5:34 am
Re: Calculation Using If Condition
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.