contract yr

[rajni_batra]

Hello ,

I have attached a dummy file to explain my problem, In sheet one there is a contract with given Valid from valid to date

and in sheet 2 there is year on year variance for same contracts,

In sheet 3 i have mentioned the output desired.

i.e. if two contracts have diff valid from date but user wants them to be in a single column for there respective 1st contractual , 2nd contractual year and so on .

Any help would be appreciated!!! thanks

Regards,

Rajni

[rajni_batra]

Any suggestions on this plz

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[rajni_batra]

Thanks Wassenaar!!! This is really helpful..

Will ask if i stuck at any point,,,,

Thanks Again

Regards,

Rajni

[rajni_batra]

Hello G,

again i need ur help hope u will help me out

Described the desired output in sheet 3 .

Regards,

rajni