Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Sum(1) and count(1) is the frequency of the value in the data model
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)