4 Replies Latest reply on Jan 23, 2016 6:08 AM by dan alexandru

    If statement with aggregate and non aggregate items

    dan alexandru

      Hi there!

       

      I've been trying to find a solution to this but no luck.

       

      I need to create a calculated field displaying the SLA% based on last 7 days.

       

      So far I have the following calculations:

       

      Calculated filed for Last 7 Days (values True or False). This is based on the date.

       

      SLA% is an aggregated field (between items in SLA/ total items in SLA buckett)

       

      I've tried if [Last 7 Days]=True then [SLA%] END and also tried LOOKUP(WINDOW_MAX(iif([Last 7 Days],[SLA%],null)),0) but I think I'm not on the correct path. Any ideas? Thanks!