Forum Discussion
Solved
Hotel occupancy rates help???
hello, I would kindly ask someone's help as i am confused.... I used the following formula to receive the average rate per month on my matix but it gives me the same annual value for all months ...
- You should create a measure not a calculated column.
Using a colum it will sum values of percentage and not calculate percentage.
Regards
Mfelix
MFelix
Super User
Super UserIf the columns are on the same table no need to create a calendar. Use the formula as I wrote and check if it works.
Regards
MFelix
Regards
MFelix
unfortunately it continues to give me as result the annual total percentage and not the monthly one....(((
I cannot understand what is going wrong