Forum Discussion
Argument '4' in CALCULATE function is required.
CSAT% =
VAR _CASTCount =
CALCULATE(([Just Count]),
NPS[Survey Type] ="Overall Satisfaction",
NPS[Survey Result] IN {8,9,10}
)
VAR _ALLCount =
CALCULATE([Just Count],
All(NPS),
NPS[Source Type] = "Overall Satisfaction",
)
RETURN
DIVIDE(_CASTCount,_ALLCount)
I am getting this error how to fixed it
Anonymous hi, try it, You have a coma left
CSAT% =VAR _CASTCount =CALCULATE(([Just Count]),NPS[Survey Type] ="Overall Satisfaction",NPS[Survey Result] IN {8,9,10})VAR _ALLCount =CALCULATE([Just Count],All(NPS),NPS[Source Type] = "Overall Satisfaction")RETURNDIVIDE(_CASTCount,_ALLCount)
2 Replies
DimaMDSolution Sage
Anonymous hi, try it, You have a coma left
CSAT% =VAR _CASTCount =CALCULATE(([Just Count]),NPS[Survey Type] ="Overall Satisfaction",NPS[Survey Result] IN {8,9,10})VAR _ALLCount =CALCULATE([Just Count],All(NPS),NPS[Source Type] = "Overall Satisfaction")RETURNDIVIDE(_CASTCount,_ALLCount)