Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
2 years ago
Solved

hi

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

 

 

1 Reply