Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
i have a field with values greater and less than 0.
so, i need to make a set analysis where if the value of A is greater than 0 is sum with a field B, and if it's less than 0 is sum with a field C.
Thanks.
No need for an if statement:
Sum({<A = {">0"}>} B) + Sum({<A = {"<0"}>} C)
Jonathan
You don't seem to ask a question in your post, but based on the subject I assume you want to know how to do a conditional sum?
Set analysis limits (or extends) the set of data the formula is working on, so that's not the way to go here. If is the function you want:
=SUM(IF(FieldA>0,FieldB,FieldC))
This wil check the value of Field A for each record and if it is greater than 0 it will add FieldB to the total sum, else Field C
Hope that answers the question you didn't ask