SUMMARY Formula on ITEM(Time Period)

Options
MarkTurkenburg
MarkTurkenburg Member, ALL USERS, GroupMember, Community Member Posts: 5 Community Boss
in Planning & Modeling

Hi team,

 

I created a ITEM line item in a Time Map (Months) module & set the SUMMARY to formula. I expected it to return the FY but instead it returned the 1st item in the period. EG for FY19 it returned Jul 18

 

Any ideas on why this is not returning FY19?

 

Thanks

 

SS1.PNG

Tagged:

Comments

  • MarkTurkenburg
    MarkTurkenburg Member, ALL USERS, GroupMember, Community Member Posts: 5 Community Boss

    Hi @rob_marshall 

     

    The Time Period is set to Month but why would the FY19 period return Jul18. This is the 1st period in the hierarchy and the SUMMARY is set to Formula, not FIRSTNONBLANK

     

    SS2.PNG

     

    Thanks

  • MarkTurkenburg
    MarkTurkenburg Member, ALL USERS, GroupMember, Community Member Posts: 5 Community Boss

    @rob_marshall can you provide the Blueprint for your screenshot line items?

     

    Much appreciated 

     

    Mark

  • MarkTurkenburg
    MarkTurkenburg Member, ALL USERS, GroupMember, Community Member Posts: 5 Community Boss

    Thanks @rob_marshall 

Categories