1 Reply Latest reply: Sep 5, 2013 4:58 AM by Thomas Jensen RSS

    Number on text object

      hello,

       

      I have this expression:

       

      =num(Sum({<Date_CleanNumeric={$(v2DaysAgo)}, DimEventType.EventType={'Buy'},FactType=E({<FactType={'BasketSize'}>}),Date_Clean=,DimUserLoyalty.MemberId=>}TotalPrice),'#.##0') - num(Sum({<Date_CleanNumeric={$(v3DaysAgo)}, DimEventType.EventType={'Buy'},FactType=E({<FactType={'BasketSize'}>}),Date_Clean=,DimUserLoyalty.MemberId=>}TotalPrice),'#.##0')

       

      And serveral others.

       

      As you see i have made a num function, but it doesnt work? How come?

       

      It works fine if i dont substract 2 expressions