on 06-29-2009 2:13 AM
Hi all,
I have a requirement to convert value of type 0FISCPER into a 0FISCYEAR format. This needs to be done as a FOX formula in my parameter group. Can anyone give suggestion please? I'm new to BPS.
Thanks,
Aloy
Is your requirement to derive fiscal year from fiscal year period?? If so, you can use the below line of code in FOX. DATA FISCPER TYPE 0FISCPER. DATA FISCYEAR TYPE 0FISCYEAR. FISCPER = OBJV(). FISCYEAR = SUBSTR(FISCPER,0,4). "This gives you the year if fiscper is in the format say '2008001' "If multiple fiscpers appear in the level, use the below code FOREACH FISCPER. FISCYEAR = SUBSTR(FISCPER,0,4). ENDFOR.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thank you very much for your reply. I have tried your suggestion but some sort of data type mismatch error came out. The result of SUBSTR is of type string but the 0FISCYEAR however is non-string. As I'll just be using the fiscal year value on my IF condition, I managed to make do by defining a fiscal year variable of type string and use this to assign the result of substr. Now it works.
Thanks again.
Aloy
User | Count |
---|---|
96 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.