I have a table that i added a virtual column to add the values from another column and show that total:
SUM(select(Utilization Report Totals[January Prediction], [January Prediction] = _THISROW))
Table = โUtilization Report Totalsโ
Column to add all values = [January Prediction]
I am wanting one value - I want this expression to total up everything in the [January Prediction] column and give me that ONE result. Yet it is showing โ$0.00โ for each row it added:
What is this supposed to doing?
[January Prediction] = _THISROW
I thought i needed that to force the expression to ONLY look at that row
Please provide a screenshot of the Utilization Report Totals that includes the column headers, or a screenshot of that tableโs column list in the app editor.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |