Derive new field

[Anonymous]

Hi ,

i have 2 fields contract term,Contract term Details.

if Contract Term is 2 Years-> In Contract Term  Details -> Year 1 of 2,year 2 of 2

if Contract Term is 42 Months ->In Contract Term  Details-> Month 1 of 42,Month 2 of 42 ,...........Month 42 of 42

How to achieve this

Thanks in advance

[anbu1984]

T1:
Load Distinct *,IterNo() & ' of ' & No & ' ' & Str As [Contract Term Dtls]  While IterNo() <= No;
Load Distinct [Contract Term], SubField([Contract Term],' ',1) As No,SubField([Contract Term],' ',2) As Str Resident Forecasting Order by [Contract Term];

[Anonymous]

Hi Abu,

Can you post sample ,i didnt get your code

Thanks for your time

[anbu1984 · Accepted solution]

Check this app