Afternoon all!
So I have this table where basically my users will enter an total amount of an allowable for a daily meal per diem and I want three additional fields (breakfast, lunch, and dinner) to populate amounts based on a percentage of the original daily total amount (breakfast at 29% of total, lunch at 27% of total, and Dinner at 54%). I can get it so it returns the total meal per diem for that row but as soon as I add the product and the .29 for the breakfast percentage it gives me an invalid syntax error. Any ideas?
=Product(INDEX(International_Meal_Per_Diems.International_Total_Meal_Per_Diem,ROW()),.29)