Sujit  Jha

Sujit Jha

  • NA
  • 25
  • 5k

how to write BMI formula in crystal reports..below my code

Apr 19 2017 12:35 AM
Anyone can help me how to write BMI formula in crystal reports 10. I want to display numeric value like 55.5.
Here is my code...
If {TableName.Weight}<>'' and {TableName.Height}<>'' then
(IF NumericText({TableName.Weight}) and NumericText({TableName.Height}) then
(If ToNumber({TableName.Weight})>0 and ToNumber({TableName.Height})> 0
then ((ToNumber({TableName.Weight})/ToNumber({TableName.Height}))/ToNumber({TableName.Height}))*10000;))