Calculation in straight table

[#1]

Dear Community,

As shown in the sample document, how can show a new column where its available= 1 and sum of that particular type?

so I would like to see sum of typeA, 3+4+3 = 10, sum of typeB = 4 and so on...

Thanks and best regards,

Chanel

[alexandros17]

Here it is

[sushil353]

Try this:

Sum({$<available={1}>}F2*F3)

[#4]

You can use the following for calculating sum:

=Sum({$<available = {1}, F1 = {'Type A'}>} F2*F3)

Hope this helps!

[sudeepkm]

Please take a look at the attachment. I've few questions. Do you just want to show the TypeA in the chart?

Do you just want to show the row where available =1, what about available =0 do you want that ignored in the row in the st Table?

[#6]

Thanks for the suggestion, but I want to get sum of TypeA which is 3+4+3 = 10, as well as sum of TypeB = 4 in the new column.

[#7]

Thanks for the suggestion, is closer to solution now, but I want to get sum of TypeA which is 3+4+3 = 10. Is it possible to make it?

[#8]

Thanks for helping but sorry, the formula is not working with the " F2*F3) “

[#9]

Thanks for your questions and suggestion. I want to show the row where available = 1, and sum of the type in that row where available = 1.

so in the new column, i would like to see sum of TypeA which is 3+4+3 = 10 and TypeB = 4.

Thanks and best regards,

Chanel

[#10]

Hi Chanel,

Does this do what you need it to do...

If(F1='TypeA',sum({<F1={'TypeA'}>}TOTAL F2*F3),sum({<F1={'TypeB'}>}TOTAL F2*F3))

Julian