Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

WebFOCUS Totaling on column's computed using the LAST function


Manoj Chaurasia

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...