Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please how can i write this correctly in a set analysis
sum({<Field1<>Field2>}amount)
sum({<uniqueid={"Field1<>Field2"}>} amount)
you need a unique record identifier
Hi....
Try like this:
=Sum({<Field1={"<>Field2"}>}amount)
Hi Mario,
if Field1 <> all Field2 selected
Sum({<Field1-=P(Field2)>} Amount)
If This is per row
Sum(If(Field1 <> Field2, Amount))
Regards,
Antonio
giakoumis correct (almost) - you need to have an equal-sign after the first double quote " :
Sum( { < uniqueid = { "=Field1<>Field2" } > } amount )