Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FRS Reports - Suppression of Formula Row

edited Mar 8, 2021 5:52PM in Reporting and Analytics for ERP 6 comments

Summary

In FRS Report tool, if I insert a Formula Row (multiple), is there a way to suppress this row if it is 0.00?

Content

I recently created an FRS report using the FRS Report Studio Tool. In one row I inserted 6 data row for Revenue by our Service Type. Right under that, I inserted 6 Formula rows to divide our total enrollment by that product against the Revenue for each row. I was able to suppress the revenue rows where the dollars equal to 0.00, but when trying to do the same for the Formula row's the suppression is not working. Is there a way to suppress the rows with formulas where they are returning 0.00. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!