1 Reply Latest reply on Aug 13, 2012 11:41 AM by Mark Holtz

    How can i use differential formulae based on a value present in a field?

    Ishan Sharma

      Hi,

      We are facing an issue with using aggregated and not aggregated functions.

      Is there any way we can use different formulae depending on a value present in a field.

      Attaching a sample workbook. We are facing issue with the Calculated field "SUM"

      Please note:

      • We know we can use parameters to achieve what we want, but in parameters, multiple selection is not allowed- so we cannot use parameters in our case

      • In the data that we have provided, you can easily change sum(Month1) + sum(Month2) to Month1 + Month 2, but this cannot be done in the data we are working with. The Two fields – SUM1 and SUM2 have to be aggregated functions.