Everything posted by nhunsaker
Is it possible to schedule email delivery of report charts that would normally be accessed by user login? It would be nice rather to have emails delivered to those user accounts rather than requiring the user to login regularly to view the chart. For example, the user login is an email address that restricts access to a report generated specifically for the owner of that email address. Rather than the owner of that email address logging in to view a data page, is it possible to automate the delivery of the view of that data page on a daily basis based upon the unique email address?
I've got a similar issue as aam82. I get the "Error in the formula" even if the formula appears valid in a calculated field. I basically tried to create an aggregation in a calculated field using SELECT and the SUM function from a child table to tabulate the sum for a particular category. This might not be the proper way to do this but I need to compare the aggregated value to another calculated field. Are there any alternatives to doing these more complex calculations involving making calculations of aggregations against other non-aggregated calculated fields?
I'm a little uncertain how this can be done. What I have essentially, is a lookup table that is combined in a view with a large spreadsheet. The lookup table indicates a target value that is matched up in the view to the spreadsheet based upon the initials of a person. The view is then used in a data page. However, in the data page I'd like to calculate the difference between the target (extracted from the lookup table to the view) with an aggregation that uses the SUM for the individual initials having records in the spreadsheet. It appears the data page doesn't allow the aggregated fields to