Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
Not applicable
Author

Nevermind, already solved it It just came to my mind when i wrote it that i could try NUM outside the whole expression, and then it works.

View solution in original post

1 Reply
Not applicable
Author

Nevermind, already solved it It just came to my mind when i wrote it that i could try NUM outside the whole expression, and then it works.