Showing all keys for the current fiscal year on selection of monthyear

[ruma_barman]

Hi All,

I have a requirement to find rate .If I select a monthyear all the keys(key field) of the current year should give rate.But the rate should be of highest monthyear.

For E.g if this is the data:

Key,Date,Rate

1,22/08/2017,11

2,22/08/2018,12

2,22/07/2018,13

3,22/07/2018,14

On selection of  Aug'18 The output should be

Key,Rate

2,12

3,14

On selection of  Jul'18 The output should be

Key,Rate

2,13

3,14

[Anonymous]

On selection of Jul18 it is working, but why would Aug18 return 12 and 14 when the rate of 14 is not in the August month?

Please explain what you are expecting, because the results are correct.

[ruma_barman]

Hi Ruan,

Since key 3 belongs to that fiscal year.All the keys of the selected fiscal year should give rate.If it isn't present in selected monthyear,it should show the rate of last monthyear.

[jyothish8807]

Hi Ruma,

In that case the output for Aug'18 also should be below:

Key,Rate

2,13

3,14

Br,

KC

[ruma_barman]

Hi Jyothish,

If the Key is present in current selection month,it should give the rate of that month.

[ruma_barman]

Morever if a key is not present in Aug'2018(if  Aug'2018 is selected) and present in both Jun'2018 & Jul'2018 ,it should give rate of Jul'2018