How to pick mid value in Rtc

Lamba

Hi Experts,

I have a customized report for which some Discount calculation is done in classic.
I have developed the Rtc report for the same, Discount calculation part was flowed from classic to Rtc via a
variable, to get the value of that variable last(Exp) is used in Expression, but in my case there is another fields which get calculated at the end and so the value of the variable at the last is Blank, so it pick the Blank value instead of the required value.So how could i pick the mid value in Rtc.
Screenshot attaced.(About this Report).

Troubles_In_Paradise

I think it's a problem of where you print that value, the "mid" function does not exist .
Could you attach the screenshot of VS layout?

Lamba

hi,
Can you please how that value be picked up. The value is printed at the footer of the table.

Troubles_In_Paradise

Without seeing the layout I can only suppose ...
You could create a group in the table, move the value in the group's footer and leave the "last" function.
creating the group the last function will retrive the last record of that group and you should get what you need.

skulla

If last value is the highest of all and if you want to display that value then you can use Max() function. There is no function to get mid value you have to create another variable in classic and assign the desired value in it and use that field to display it in RTC.

Troubles_In_Paradise

Today I had the possibility to test what I suggested you.
In report of our customer I had the same situation as you.
I've to print the yellow value and after this line I've 2 blank lines (see attachment 1).


Solution:
1. created a group in the table
2. moved value from Table Footer to Group Footer
3. Field called with "Last" Function.
4. Test -> It works (see attachment 2)

Lamba

Thanx Paradise.

Troubles_In_Paradise

Welcome.