CODEWITHSUNDEEP
reporting-servicesssrs-2008
Neo
Neo

Reputation: 16219

how do i make addition of two fields in ssrs expression?

I have generated one ssrs report

now i have two fields having values

1st field value is =Fields!FirstNO.Value

2nd field value is =Fields!SecondNO.Value

now i have one field average and i need to write expression like

average = (Fields!FirstNO.Value+Fields!SecondNO.Value) / (Fields!SecondNO.Value)

how can i write above in expression?? directly as i shown or any other syntax is there please help?

Upvotes: 1

Views: 6539

Answers (1)

Hong Ning
Hong Ning

Reputation: 1003

Are you sure these fields are numeric? Maybe try convert to numeric, like =cint(Fields!FirstNO.Value)

Upvotes: 0

Related Questions