Inputsum and inputfield and unaggregated calculations
I'm using Inputfield and Inputsum to allow interactvity in a table chart. Inputsum works at an aggregated level, but I want to use the input value to run a calculation at a detailed record level and then aggregate the output. I am using the Inputfield to allow the end user to change their Minimums.
I'm using the following table to show the calculation that I'm attempting to perform with minimum being used as the input column.
The formula is sum the greater of the following two
That just about did it. I played with it and the following got me what I needed. I needed to treat the InputMinimum field as a field and the place where I enter the data needed to have the formula updated to InputSum(InputMinimum,'=').