Expression in Qlik Sense

[#1]

I used this expression in qlikview and it's working fine.

total revenue:

sum(aggr(((Count(AppointmentID) * sum(VisitAmount))), [Doctor]))

But it doesn't working in qlik sense !!

I need help to calculate the total revenue.

[marcus_sommer]

There is no difference between qlikview and qlik sense related to these kind of expressions - therefore something else must be different - check the syntax (too much parenthesis aren't helpful - it's rather the opposite) and that there no typos and also that fields are case-sensitive.

- Marcus

[#3]

sum(aggr((Count(AppointmentID) * sum(VisitAmount)), [Doctor]))

should work (have moved your brackets around a little)