Forum Discussion

Seanan's avatar
Seanan
Icon for Solution Supplier rankSolution Supplier
4 years ago

Blanks in matrix won't replace

Hi guys, so I have a matrix where I am using UNICHAR's to represent answers that are either correct, incorrect or not attempted.   I am having a tough time trying to replace the blanks in my matrix...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi Seanan ,

How about adding another argument to your SWITCH formula? Try using this one instead:

AnswerGraphic =
SWITCH (
    TRUE (),
    'ItemCompleteSplitLang'[AwardedMark] >= 1
        && ItemCompleteSplitLang[Attempted] > 0, UNICHAR ( 9989 ),
    'ItemCompleteSplitLang'[AwardedMark] < 1
        && ItemCompleteSplitLang[Attempted] > 0, UNICHAR ( 10060 ),
    'ItemCompleteSplitLang'[Attempted] <= 0, UNICHAR ( 128992 ),
    "0" // return "0" if the other criteria are not met
)

 

Seanan's avatar
Seanan
Icon for Solution Supplier rankSolution Supplier
4 years ago

Hi danextian,

Unfortunately still no luck.

I've been having this issue for quite a while with this matrix and can't figure out why.