We would like to be able to expand the options for calculated properties. It would help if we could calculate a sum based on multiple conditions and if we could have the option of does not equal instead of just equals. Currently, we can only select one Additional Condition to define when the property in question should be calculated. We have instances when we need to sum a property based on the data in other related properties or even multiple options within one related property.
Example 1: Sum Product Lift when Asset Class is equal to New or Asset Class is equal to Renewal.
Example 2: Sum Product Lift when Asset Class is not equal to One-Time.
Example 3: Sum Product Lift when Asset Class is not equal to One-Time or Billing Frequency is not equal to One-Time.
