In my Dataset I have 3 columns "EducationLevel","Skill" and "PreferenceType".In the report I have a field called marks.I give marks adding above 3 column values.i.e
If "EducationLevel" is (High,15 marks),(Medium,10marks),(Low,5 marks).
If "PreferenceType" is ("First" 15 marks),("Second" 10 marks),("Third"5 marks)
If "Skill" is (High,15 marks),(Medium,10marks),(Low,5 marks).
The Marks field should display aggregate of all 3 marks obtained from above 3 fields.
How can I write the expression for it?
thnx in advance
All 6 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.