What is Sum(1) ?

[mhmmd_srf]

Hi All,

I am confused in one expression.

If I write sum(1), it is showing some values.

Please check my new sheet in attached App.

Thanks,

Sarif

[tresesco · Accepted solution]

Using sum(1) across a dimension would mean, summing 1 as many times as the dimension values are there. That is, it would be similar to =Count(YourDimension), i.e. =count(Z_FROM_TIME)

[techvarun]

Sum(1) and count(1) is the frequency of the value in the data model

[woshua5550]

You can assume that you have a filed "Counter" which contains 1 for each rows of your table "ORD_VOL"

Sum(1) = Sum(Counter) and also

Sum(1) = Count(<one arbitrary field in table ORD_VOL>) , e.g Count(SHIP_LINE_CNT)

in addition Sum(100) = 100 * Count(SHIP_LINE_CNT)