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!