0

Two separate tables by month. I need to use the monthly amount from table 1 with the monthly total in table 2 for a frequency calculation.

This expression retrieves the last months total from table1.
=(SUM(Fields!ClaimCount.Value) / SUM(Fields!InsCnt.Value,"ds_Table1"))

Is there a way to calculate this and match the months for each table?

Example

enter image description here

M Anthony
  • 13
  • 3

1 Answers1

0

As each textbox is static in your tables then each will have its own name.

Click the cells you want to do hte calculation on and get their names from the properties window (e.g. the one you have selected in you screen shot is "TextBox14"). Once you know the names of the cells you can use the ReportItems collection.

=(ReportItems!TextBoxB17.Value / ReportItems!TextBoxB8.Value)
Alan Schofield
  • 19,839
  • 3
  • 22
  • 35
  • Thanks I've tried that. The report item from the top table is the December total. I'm trying to match the month. January amount from table 1 divided into January total from table 2. The calc above takes January total from table 2 divided by December total in table 1. – M Anthony Feb 20 '20 at 20:15
  • Sorry I didn't notice that the months are in a column group. You may have to use a LOOKUP or LOOKUPSET to get the values from the top table – Alan Schofield Feb 20 '20 at 21:24
  • Yes I need to use a LOOKUPSET. Also had to use the following function. https://stackoverflow.com/questions/36131860/need-help-in-calculation-using-two-datasets-using-expression-ssrs/36143175#36143175 – M Anthony Feb 25 '20 at 15:27