Forum Discussion
Solved
Calculation from a lookup table with default
I have two tables, an aggregated table(AggrTbl) and another table (Lkup) is a lookup table. They are separate now but can be joined by Staff Name. I need help in calculating the Cost. In...
Try something like this:
Cost =VAR varLookup =
LOOKUPVALUE (Lkup[Rate];
Lkup[StaffName]; AggrTbl[StaffName])
RETURN
IF (
varLookup <> BLANK();
varLookup;
50)
Regards
Try something like this:
Cost =
VAR varLookup =
LOOKUPVALUE (
Lkup[Rate];
Lkup[StaffName]; AggrTbl[StaffName]
)
RETURN
IF (
varLookup <> BLANK();
varLookup;
50
)
Regards
Worked perfectly. Thank you so much.