Invalid dimension in table using calculated dimension

[kaoaoa]

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!

[Qlik1_User1]

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')
)