Search results for query: *

That sounds better. I've given it a try, and that formula keeps failing with syntax errors. After thinking about it, I think I know why it's failing. There isn't a measure that goes down to individual product level. (I didn't design this thing, I hasten to add) So that formula would have...

Thanks Hurdles Oh dear. I was counting on being able to do that with the equivalent of a CAST sort of thing. But your beer/diet/cola point makes perfect sense. I could do the IF statement thing, but there's a lot of different pack sizes, and the list of pack sizes could grow. Hard coding...

Hi there, Newbie here - tip of the hat to y'all. Situation: Sales Cube. We sell tablets in many pack sizes. We have PackSize as a dimension, so we can see how many 1 packs, 6 packs, 12 packs etc that we sell. This is expressed in a PackSales measure, which shows how many packs were sold...