var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have the following calculated field on a report
It works great. How can I have this field peak at a specific number. For example anything that reaches "112" will be brought down to "95" while still using all the rules in the code above? Can I put two of these IIf statements in there somehow?
Yes, you could change
=IIF( IIf([field1]/100>0,[field1]/100,0) >=112,95,IIf([field1]/100>0,[field1]/100,0))
The problem is that the formulas is evaluated twice
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors