Dear Team, I have a business scenario (refer to attached file). The Formula for Net Volume is not working because Returns % are maintained by Year however even if the Returns % are maintained by Months it is not picking up the values In addition to above, YEARVALUE does not allow selection using SELECT or LOOKUP as parameter. For Example: YEARVALUE (Returns (LOOKUP: REGION) OR YEARVALUE ( Returns) [LOOKUP: REGION) gives error messages Given above I could ask Users to maintain the returns % by month, add a formula as following to read return % IF Customers.Territory = Territory.US THEN Returns[SELECT: Territory.US] ELSE 0 Question is there is a better way to achieve above? Thanks for reading my post (refer attachment) and look forward for your suggestions! Cheers, Umesh
Solved! Go to Solution.