numbers

2 Topics

Using IF function - but still want to be able to sum results (as numeric) ...?
Hey! I'm trying to update a rewards program at work where we want to be able to both see if (yes/no) a customer deserves a reward, but also group the level of reward each reacieve in form a points. I've managed to establish Yes/ No by using = IF (Purchase >= 92 , "Yes", "No") E.g. if Purchase is over 92 then Yes they should recieve an award, otherwise no (92% represents the % the limit they need to hi) I've similarly been able to use the If function to group the points = IF(Purchase = 92, "100", IF(Purchase = 93, "200", IF(Purchase = 94, "300", "0"))) This successfully groups the customers into groups based on the % they have hit (e.g. they show up in a table as 92% represents 100 , while 94% represents 300) My problem is however that I cant sum up the to total amount of points collected. As I want to track the total per month - the IF formula does not seem to be beneficial. I would very much appreciate it if someone could suggest another formula where I can still group the data but keep the results as numeric values that can be summarized in a table. Thank you!
Solved
Pandetbaby
6 years ago Place DAX Commands and Tips
1.3KViews
0likes
5Comments
Number formatting showing up differently for different users
We've published a report on Report Server. THe report connects to a SSAS data model. A couple of users have reported that they are seeing the numbers formated differently from what I see it as. I see it as $4,877,089 whereas the other users are seeing it as $48,77,089. These others are in India and I am in the US so I'm guessing it's something to do regional settings. How can it be changed at a report level so users are seeing it exactly the way it has been designed? In general, we want everyone to see the numbers as $4,877,089.
vickyd
8 years ago Place Report Server
3.2KViews
0likes
7Comments