Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
On the attached application the column labeled Charge / Sow takes the average number of sows for the date range selected and divides the Charges by that amount which works fine on the individual farm basis, but this caused me a problem with the total row. I need the total row to calculate by dividing the total Charge ($4,388.72) by the Avg Sows on Hand (65,409) and return the correct Charge/Sow (.0671). Any help on this will be greatly appreciated.
Use the dimensionality() function.
If(Dimensionality() = 1, <Expression you want to use for total here>,
<Expression for rows here>)
That helps, but the other part of my problem is that I can do a SUM(Total for the Other Costs), but I cannot do this for the FarrEndSowsOnhand because it is an average of the period selected. Any further suggestions?