Sum all fields from lookup SSRS

Asked Jul 08 '14 at 06:24

Active Jul 08 '14 at 06:24

Viewed 48 times

I try to sum in the end of a table, one column is a lookup. When i run it over multiple days and try to sum the lookup for all days like

=Sum(Lookup(Fields!.Value,Fields!.Value,Fields!.Value, "table_1")

If I keep it without the Sum, it only takes the first value from the first day. If I have the sum, a ridiculous number appears

asked Jul 08 '14 at 06:24

Edvard Åkerberg

Please refer http://stackoverflow.com/a/8094130/3198474 – Naveen Kumar Jul 08 '14 at 09:21
1

@NaveenKumar i try to but the "SumLookup" gets red, any solution? – Edvard Åkerberg Jul 08 '14 at 10:00
Have you added the SumLookup Function to your Custom Code in your Report Properties? – user2900970 Jul 09 '14 at 08:34
@user2900970 Yes i have, still not working. This image describes what i wanna do. I want to sum that lookup, expresseion of capacity. http://cdn.imghack.se/images/9af92a3e97839bf4238f9cb82b556c89.jpg – Edvard Åkerberg Jul 09 '14 at 10:26

0 Answers0