4 Replies Latest reply: May 30, 2016 5:19 AM by Rinus Reus RSS

    Group by

    Rinus Reus

      Good morning,

       

      Who can help me with this problem i have.

      For the calculation of the wault i use the next expression;

       

      avg({$<CAMRULE_HCHARGECODE = {4,5,23}>}

      if(LEN(TRIM(TENANT_DTBREAK)) = 0 AND TENANT_DTBREAK > floor(now()) and CAMRULE_RENT_YEAR > 0,

        (TENANT_DTBREAK - floor(now())) / 365.25 * CAMRULE_RENT_YEAR,

        if(TENANT_DTEXPIRATION > floor(now()) and CAMRULE_RENT_YEAR > 0,

         (TENANT_DTEXPIRATION - floor(now())) /365.25 * CAMRULE_RENT_YEAR)))

      / CAMRULE_RENT_YEAR

       

      This calculation does exactly what i would expect it to do but it's per tenant and when i remove the dimension tenant to see the wault for the selected properties all results will be removed.