You are viewing limited content. For full access, please sign in.

Question

Question

Table Percentage Calculations

asked on March 8, 2018

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)

0 0

Answer

SELECTED ANSWER
replied on March 8, 2018

Hi Drew,

Can you try replace ".29" with "0.29" in the formula? ".29" is not a valid number that formula would support.

0 0
replied on March 9, 2018

Thanks Rui!  I knew it had to just be something very simple that I was missing. 

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.