how to write formula in crystal report

Question

how to convert this into crystal report formula  select SUM(ISNULL(QT.QuestionTarget0)+ISNULL(QT.QT_FormMen0)+ISNULL(QT.QT_ForWomen0)+ISNULL(QT.QT_ForGirl0)+ISNULL(QT.QT_ForBoy0)) AS TARGETTOTAL from QuestionTarget AS QT Where Year=5 AND QT.District=8  where 8 is parameters you can write ?districtID any one help thanks in advance

Danish Habib · Answer

I am asking about where cluase i am wrote formula using sum function but how to achieve where clause where districtId=7 how to achieve this

Daisy Princess · Answer

You can use the sum function in the crystal report formula editor. Since it crystal report these fields are treated as a field where you can use sum() function for formula editor.