Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check this app
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];
Hi Abu,
Can you post sample ,i didnt get your code
Thanks for your time
Check this app