Forum Stats

  • 3,769,346 Users
  • 2,252,951 Discussions
  • 7,874,992 Comments

Discussions

Using @SUBSTRING in a FIX possible?

3921866
3921866 Member Posts: 48
edited Apr 15, 2020 8:57AM in Planning and Budgeting

My outline is in red to the right.   My Fix is in Green to left.  My PBCS Calc Mgr Log is below.

The rule validates.  But when it runs, it doesn't just AGG 'FY20' and 'Apr'.  It's aggregating the entire years and periods.

Can I derive just the 'Apr' and the 'FY20' from my outline members into a FIX?  I'm stumped and no idea at this point.  Can't seem to find any help.

Thanks for reading and any assistance!

pic.bmp

Tagged:

Answers