Forum Discussion
Use Total Record to Create Future Estimate
Super Userfsu5078 , Not very clear. But you can use numeric parameter and then have measure like
[% Wells Collection] * selectedvalues(param[Value])
or
calculate([% Wells Collection], allselected()) * selectedvalues(param[Value])
Thanks amitchandak and sorry for not making this clear.
I have a filter on this report to show only the prior year. The % Wells Collection column is a measure field based on a division formula from two other columns in the table so that it would tell me what % of the total funds collected belonged to Wells. From there, I wanted to find what the average was and use that to help me determine what future estimates could be.
I couldn't seem to find a way to create the average of this one column (% Wells Collection) other than showing it in the Total Record (which I highlighted in the print screen). I now want to apply this one figure (32%) against future values.
For example, if 9/15/23 has an estimate of $1M, I would like to take future amount * % (1M * 32%). Then 9/18/23 has an estimate of $2M, it would be $2M *32%.
Is there a way to reference the amount shown in the totals section (32%) in a column or measure?
I apologize if I confused you even further.
