I am giving it my best with RDLC for the first time. I am not a full time programmer, so i am struggeling a bit on getting it all done, so your help is much appriciated.
I am doing a report that contains measures grouped on 2 values:
the report has a table:
Flow | Meter | measure | diff | avg
10 L | 20 L | 20,02 L| -0,02 L |
10 L | 20 L | 20,04 L| -0,04 L | "-0,03 L"
20 L | 5 L | 5,02 L| -0,02 L |
20 L | 5 L | 5,02 L| -0,02 L | "-0,02 L"
The avg column is my problem at this stage. The rest is stored in the database and calculated in input. the avg column only needs to be there once, is calculated as an average on the diff and based on the grouping of the 2 first columns - so only on either the first or the last row of the "group"
An idea or direction any of you wise people can help me with?
What I have tried:
I have googled and watched dusins of youtube videoes, but havent found anyone with the same calculation.