Filter Full Year

Options
Muh_Arief
Muh_Arief Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Contributor

i want to ask, i have module like this the module have 2 lines item actual and budget for the display i used filter for this, but the problems is in the full year the line item is actual, i want to change to bottom up amount, so if on the FY 21 have actual and bottom up amount FY is Bottom up amount and if FY 21 is actual FY is Actual, if FY 21 Bottom up FY is Bottom Up

Muh_Arief_0-1612424876697.png

the formula filter is, i created line item subset first for this 

Muh_Arief_1-1612425074239.png

 t

 

Comments