Crystal reports formula
if{((tonumber({BudgetTemplateField.Expr1})- tonumber({BudgetTemplateField.Expr3})) > tonumber({BudgetTemplateField.Expr1}))}
then
{
((tonumber({BudgetTemplateField.Expr1}) - tonumber({BudgetTemplateField.Expr3})/tonumber({BudgetTemplateField.Expr1}))*100)
}
else
{
开发者_运维知识库@add
}
//please provide solution for this error
I think the code should be like this:
if((tonumber({BudgetTemplateField.Expr1})- tonumber({BudgetTemplateField.Expr3})) > tonumber({BudgetTemplateField.Expr1}))
then
{
((tonumber({BudgetTemplateField.Expr1}) - tonumber({BudgetTemplateField.Expr3})/tonumber({BudgetTemplateField.Expr1}))*100)
}
else
{
@add
}
i think it will work.reply.
精彩评论