Manoj Chaurasia Posted April 14, 2022 Share Posted April 14, 2022 I have a request to add totals to a report on a BY field where on of the columns is computed using the LAST function and the report is an Across Report. The across is on MM/YYY date field. The condition requres that the totals still be calculated using the last value from the previous months with the current months value Something like this COMPUTE MARGIN_DIFF_PCT/D12.1%=IF (SHIP_MY GT LAST_SHIP_MY AND LAST_SHIP_MY NE '') THEN (CONTRIBUTION_TOTAL - LAST CONTRIBUTION_TOTAL )/ LAST CONTRIBUTION_TOTAL * 100 ELSE 0; Using a RECAP or RECOMPUTE does get me the correct values. Has anyone had this type of request before I have added a screenshot of the report I am creating and highlighted the fields which need to be calculated. Thanks, Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now