Variable dependant on marked items

[#1]

Dear All,

I am using QV to create a load file for another reporting tool. This load file has a date fields (D_DP, D_PE) in a format rrrr.mm . In my accounting data loaded to QV I have as well month variable and it would be cool to make the data in D_DP & D_PE dependant upon the no of marked months in my MONTH field, as per the below:

No of marked fields           data shown in D_DP & D_PE

2                                        2015.01

3                                        2015.02

4                                        2015.03

...

13                                        2015.12

I know I can not necesarely choose 2,3,4, subsequent months, however if there is no simple way to control it, then I would live with this potential risk.

Can you please help with proper formula for D_DP and D_PE fields? So fat it is just ='2015.10' and I change it manually at loads for sifferent set of months.

I attach a picture of part of my table and MONTH variable

thanks a lot in advance for your hints

[anlonghi2]

Hi Drazsor,

use GetSelectedCount(MONTH) to know the number of selected months and then use the value to show D_DP & D_PE

Best regards

Andrea

[#3]

thanks a lot Andrea,

works perfectly

Best Regards

Robert