summing an equation

[anriretief]

I would like to sum the following equation ([VERVOER-TARIEF] + VERVOER)*[FAKTUUR MASSA]/1000

I have tried the regular summing function but it doesn't seem to work

There is also a condition on this sum: [TIPE GRAAN] not equal to 'WITMIELIES'

Can someone please help me with this

[Anil_Babu_Samineni]

Sum Aggregation only works Numeric not for characteristics. So, You would need this if it is number

RangeSum([VERVOER-TARIEF], VERVOER)*([FAKTUUR MASSA]/1000)

[anriretief]

Thank you!

It works, I appreciate your help

[marcus_sommer]

I assume that you need something like this:

sum(aggr(

sum({< [TIPE GRAAN] -={'WITMIELIES'}>} ([VERVOER-TARIEF] + VERVOER)*[FAKTUUR MASSA]/1000),

YourChartDimensions))

whereby the aggr is only needed if you want to display partial sums or totals.

- Marcus

[anriretief]

THANK YOU!

[Anil_Babu_Samineni]

You can flag "Correct answer" follows Qlik Community Tip: Marking Replies as Correct or Helpful