I would like to calculate a cost where I have the number of items and the unit price and the sum per category is (of course) calculated number of items * unit price. The total cost is the sum of all catogory sums.
I also have price ceilings for some items where a have a calculated unit price since before * the number of items UNTIL the ceiling is reached. How can I get this logic into Qlikview?
