5 Replies Latest reply on Apr 25, 2017 3:22 PM by Justin Larson

    LOD calc... maybe?  I need a way to use MAX or SUM depending on certain situations

    Justin Pulley

      I have some data where there are some projects all have a Project ID, but some share a Capital Request (CR).  The data is all in table layout.  What I am trying to do is say IF there are multiple project IDs with the SAME CR then MAX([CR]) should be shown, otherwise SUM([CR]).

       

      I tried IF {FIXED [CR] : COUNT([Project ID])} > 1 THEN MAX([CR]) ELSE SUM([CR]) but it didn't like that.  Is there a way to do an if statement that says if a CR has multiple projects use MAX, but use SUM otherwise?