hi

[abc_777]

Hello,

I try to create alart

Alerts =

UNICHAR(10) &

"Product:" & UNICHAR(10) &

CONCATENATEX(

    VALUES('bm_retail_t product_file'[VALUE_TYPE]),

  -- Notification Values

    VAR _ValueQuantityGrowthWoW = FORMAT([% Growth Quantity WoW], "+0%;-0%")

   -- Show Notifications Yes/No

   VAR _ShowQuantityGrowthWoW = ABS([% Growth Quantity WoW]) > 0.15

   -- Notification Messages

    VAR _MsgQuantityGrowthWoW = 'bm_retail_t product_file'[VALUE_TYPE] & " " & " Quantity WoW " & _ValueQuantityGrowthWoW

   -- Combined Notification

    VAR _Notification =

        IF(_ShowQuantityGrowthWoW, " • " & _MsgQuantityGrowthWoW & UNICHAR(10))

    RETURN

        _Notification

) & UNICHAR(10)

but i got 

 this is not showing in table [% Growth Quantity WoW]

but i want like this

please help, thx

[abc_777 · Accepted solution]

solved