# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Multiplication inside Sum with Total

I'm trying to create a function that is essentially:

 SUM(colA * colB * Total ColC)

But it's returning nothing.

The actual expression is a little more complicated:

 If(Sum(count) <> 0, Sum([Number of Tickets]), Sum([curves.curve]*[OP.tixrsrperc]* TOTAL {<[OP.week_ending_date] = {"\$(='>=' & Date(Max({}[OP.week_ending_date], 4)) & '<=' & Date(Max({}[OP.week_ending_date])))"}>}count / TOTAL {<[OP.week_ending_date] = {"\$(='>=' & Date(Max({}[OP.week_ending_date], 4)) & '<=' & Date(Max({}[OP.week_ending_date])))"}>}[curves.curve] ) )

I verified all the individual parts work as expected.  Any ideas?

MVP

## Re: Multiplication inside Sum with Total

May be this

Sum(Aggr(

Sum([curves.curve])*Sum([OP.tixrsrperc]) *

Sum(TOTAL {<[OP.week_ending_date] = {"\$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>} count)

/

Sum(TOTAL {<[OP.week_ending_date] = {"\$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}[curves.curve]), UniqueIdentifierField))