[av_one_full first min_height=\’\’ vertical_alignment=\’\’ space=\’\’ row_boxshadow=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’\’ margin=\’0px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ padding=\’0px\’ column_boxshadow=\’\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight=\’\’ highlight_size=\’\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ aria_label=\’\’ av_uid=\’av-ye0f\’]

[av_heading heading=\’Number & Currency\’ tag=\’h1\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’\’ custom_font=\’\’ subheading_color=\’\’ seperator_color=\’\’ icon_color=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ headline_padding=\’\’ headline_padding_sync=\’true\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-dkucn\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_heading heading=\’Hide 0 unless value entered\’ tag=\’h3\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’entypo-fontello\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’\’ custom_font=\’\’ subheading_color=\’\’ seperator_color=\’\’ icon_color=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ headline_padding=\’\’ headline_padding_sync=\’true\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kumvi2fn\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kumvhj3a\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
A Number or Currency field will report \’0\’ in Report Builder if no value is entered in the field.

There are occasions you may need to report if a zero was input in a field.  You can do this will the expression below:
[/av_textblock]

[av_codeblock wrapper_element=\’\’ wrapper_element_attributes=\’\’ codeblock_type=\’snippet\’ alb_description=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-kumvl0o8\’ sc_version=\’1.0\’]
{ReportData[\”Number\”] == null || ReportData[\”Number\”] == DBNull.Value ? \”\” : ReportData. Number.ToString()}
[/av_codeblock]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kumvlgox\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
Note: Replace \’Number\’ with the field name

This expressions checks the value input in the database and will only show a zero if it was input in a Number or Currency field by the user.
[/av_textblock]

[av_hr class=\’default\’ icon_select=\’yes\’ icon=\’ue808\’ position=\’center\’ shadow=\’no-shadow\’ height=\’50\’ custom_border=\’av-border-thin\’ custom_width=\’50px\’ custom_margin_top=\’30px\’ custom_margin_bottom=\’30px\’ custom_border_color=\’\’ custom_icon_color=\’\’ av-desktop-hide=\’\’ av-medium-hide=\’\’ av-small-hide=\’\’ av-mini-hide=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ show_locked_options_fakearg=\’\’ av_uid=\’av-23mrwy\’ sc_version=\’1.0\’]

[av_heading heading=\’Implicitly defining field as a number\’ tag=\’h5\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’entypo-fontello\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’\’ custom_font=\’\’ subheading_color=\’\’ seperator_color=\’\’ icon_color=\’\’ margin=\’\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ headline_padding=\’\’ headline_padding_sync=\’true\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kumvizfl\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ av_uid=\’av-kumvjbjn\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
If you are calculating field(s) and receive an error message saying there is an invalid field type match, you may need to define the field(s).

For instance:
[/av_textblock]

[av_codeblock wrapper_element=\’\’ wrapper_element_attributes=\’\’ codeblock_type=\’snippet\’ alb_description=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-kumvlwy9\’ sc_version=\’1.0\’]
{(int)ReportData.Value)} – define field as an integer

{(decimal)ReportData.Value)} – define field as a decimal

{(float)ReportData.Value)} – define field as a float
[/av_codeblock]

[/av_one_full]