3 Replies Latest reply on Jan 9, 2019 9:37 AM by Simon Runc

Sum'ing together Measures

I have three measures - I want to ADD THEM TOGETHER for the life of me it isn't working!

my current field is like so

IF STR([Validation bool])="f" then 1 else 0 end

so I can put this on my sheet and it shows the desired number. Which is good.

I have three other fields just like the above that all produce their desired numbers but I can't ADD them all/total them for the life of me!

• 1. Re: Sum'ing together Measures

try

zn(sum1)+zn(SUM2)+ZN(SUM3)

• 2. Re: Sum'ing together Measures

Hi Tony

if you have separate measures then create a new calculated field     sum(measure1) + sum(measure2) + sum(measure3)

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• 3. Re: Sum'ing together Measures

Hi Tony,

So you should be able to use

zn([Measure 1]) + zn([Measure 2]) + zn([Measure 3])

The ZN equates a NULL to Zero, which is needed when adding across measures (1 + NULL + 1 = NULL not 2). When nulls appear in a single column the NULLs won't get counted or added in a sum, but across measures we need to use the ZN

Hopefully that's it, but let me know if that doesn't solve it