Stimulsoft Business Intelligence System | Forum

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.

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.

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

Hello

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

Thank you.