re: Help with formulas

Question

I have been trying everything I know of and have hit a brick wall.&nbsp; &nbsp; I am trying to remove the entry in the Area column (Q) if Function Room (I) is a duplicate within the Booking:Booking ID (E).&nbsp; &nbsp;Basically if the same room exists multiple times within the same Booking ID group, I don't want to count it's area in the total space calculation more than once.&nbsp;

sergeibaklan · Answer

KCortez&nbsp;
Will it work if instead of summing area in values move it to rows area after ID ?

kcortez · Answer

SergeiBaklan&nbsp; that would work - how do I do that?&nbsp;

kcortez · Answer

I responded too soon - it's in the pivot so I'm good to go - thank you

Forum Discussion

re: Help with formulas

3 Replies