Download REPORTSNOW DESIGNER TRAINING GUIDE

Transcript
ReportsNow Designer Training
1/8/2013
Conditional Calculations
• Click Design, Calculations
The Column Caption will
default to the “Value if true”
value or column name. Edit as
necessary
First , choose
Conditional as the
Type of Calculation.
Change Output Type
to match your
resulting values
Fill in all criteria for the
condition; this can include
multiple columns and literal
values
Designate a column or value if the
condition is true. You can also have
the calculation multiple or add values /
columns if the condition is true
The same columns, values, and logic can be
applied if the condition is false. Note: If you
don’t change, then a 0 will default for false
conditions; you can replace with <BLANK>
Copyright 2012 iLearnERP
77