Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm trying to make a calculated dimension which defines if, on a specific date, the shop was opened or it wasn't. If i add this as a dimension to a table it says 'invalid dimension'
This is my formula:
if (Weekday <> 'Sun', 'Open', if (Count(distinct{$<Type = {'O','N','A','S','D','L','C','B'}>} TransactionID)>5, 'Opened', 'Closed')
already tried using Aggr, but that also doesn't seem to work
Thanks in advance!
formula seems to be correct but missing oneclosing bracket
if (Weekday <> 'Sun', 'Open',
if (Count(distinct{$<Type = {'O','N','A','S','D','L','C','B'}>} TransactionID)>5, 'Opened', 'Closed')
)