Dividing values in two datasets
Hello,
In short, I am trying to divide two values, one in DatasetC and one in DatasetA. I have tried to use Lookup to do it, but to no avail.
I am recreating a report and plugging it into SSRS. I have rewritten the report in SQL and it contains 6 parts, A, B, C, D, E, F and G. I am needing to divide DatasetC by DatasetA in order to get a percentage. I have looked into this and all I can find is to use Lookup, but when I do is produces an error. Below is the formula I am using. They all connect to the same datasource. Any advice would be appreciated.
=Lookup
(
Fields!Outstanding.Value,
Fields!Outstanding.Value,
Fields!Balance.Value,
“PartD”
)
/
Lookup
(
Fields!Outstanding.Value,
Fields!Outstanding.Value,
Fields!Balance.Value,
“PartA”
)
Thank you
Hello, In short, I am trying to divide two values, one in DatasetC and one in DatasetA. I have tried to use Lookup to do it, but to no avail. I am recreating a report and plugging it into SSRS. I have rewritten the report in SQL and it contains 6 parts, A, B, C, D, E, F and G. I am needing to divide DatasetC by DatasetA in order to get a percentage. I have looked into this and all I can find is to use Lookup, but when I do is produces an error. Below is the formula I am using. They all connect to the same datasource. Any advice would be appreciated. =Lookup(Fields!Outstanding.Value,Fields!Outstanding.Value,Fields!Balance.Value,”PartD”)/Lookup(Fields!Outstanding.Value,Fields!Outstanding.Value,Fields!Balance.Value,”PartA”) Thank you Read More