Not sure where to put this...
Im working in SQL Report Builder (sorry dont know which version) and am having trouble with calculated fields.
Ive got 2 datasets - one with some tenancy information in it (DataSet1) and the other with address data in it (DataSet2)
Ive got a calculated field that ive called "DaysVoid" which is essentially one date subtracted by another.
I want to work out the total sum of all of the "DaysVoid" so have set up another calculated field which is called "TotalDaysVoid" //=sum(DaysVoid)\\ but when I run my query, I get the following error;
//The Value expression for the textrun ‘Textbox34.Paragraphs.TextRuns’ contains an error: [BC30451] Name 'DaysVoid' is not declared.\\
Can anybody help?