+15
Per this article: https://help.karbonhq.com/en/articles/6524704-kpi-table-and-column-names
| BUDGETED_COST | The budgeted cost for a work item. |
is an available field in table: WORK_ITEM_DETAILS
When I try and create a measure in that table, I can’t use the field BUDGETED_COST.
Anybody know how to resolve?
Best answer by max
View original
+10
Following! We can’t get this either.
+19
It’s generally good practice to nest measures, and the first argument for a calculate function is a calculation.
I would recommend adding a measure like this:
msr-bud-cost = SUM(BUDGETED_COST)Then nest that measure in your calculate statement:
msr-bud-cost-filtered = CALCULATE(msr-bud-cost, department = "Accounting", etc., etc.)Does that work better?
+15
Thanks
+19
It should work both ways, but there are some technical and arcane reasons why it makes sense to nest the measures like that.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
