Forum Discussion
Matej
Helper I
Helper INew calculated column
Hello, I would like to ask for a help with this specific problem. I need a calculated column that would take SUM of Amount from different product categories and divide them by number ...
MatejHelper I
Helper ISorry, I know that the explanation was not clear at all.
Basically, I have a table like this which contains multiple categories of pruducts we sell to a customer. In this table the price for the products is summed based on the category.
Next I have another table with customer details containing the amount of beds each customer have available.
What I am trying to achieve is to write a formula that would calculate daily spending for each category based on per day/per bed. I can do the math in excel in this way (which is very uneficient) = (Total price in the each of the category/30 [AVR amount of days in month])/Bed Count.
Hope it makes a bit more sense now.
Matej