Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 = ...
  • DimaMD's avatar
    DimaMD
    4 years ago

    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"
          )
    RETURN
    DIVIDE(_CASTCount,_ALLCount)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you got it