I ma trying to calculate the total number of channels in the network.
To explain better:
we have a lot of circuits ( [Circuit]) in our network with different capacity ([Bandwidth]). Each circuit is composed from a different number of channels. To understand how many channels, we use the dimension Bandwidth.
So I loaded a sort of translation table on Qlik, where there is the list of all the possible bandwidth with the number of channels.
When I am using the formula Sum(CHANNELS) it gives me back a wrong number.
For example, in the attached extract I should receive back as total 390, instead of 30.
I would also remove the dimension Circuit from the table, It is just to better explain where is my issue.