Conditional formatting and IF statement

William · August 13, 2012 8:50AM

Hi,

I am trying to recreate this (see attachment) in Omniscope. The part that I need help with is columns H, J and L. I am not sure how to go about creating it in Omniscope.

Thanks and regards,
William.

michael · August 14, 2012 5:36AM

Hi William,

In the Content view you can add a formula and set the formatting to the Indicator.
You can also specify your own icons and adjust the rules/value ranges for your icons.

paola · August 14, 2012 6:29AM

Actually this can be done in Table View too, and with use of formulas you can have arrows in a table image field.
In an images folder create small red and green arrow files, call them "Red Arrow.jpg" and "Green Arrow.jpg".
In Table View create field -
[Difference] = [Field 1]-[Field 2] (your sales figures in Year 1 and 2)

Create a new field [Indicator] and select the directory where red/green arrows are stored.
Settings>Images>Add more images , also choose the correct field to be image field
IF([Difference]>0, "Red Arrow","Green Arrow")

Depending on the value in the [Difference] field, the [Indicator] will pick correct arrow.

William · August 15, 2012 5:51AM

Thanks guys, much appreciated.

Regards,
William.

	contentview_formula_indicator.png	42K
	contentview_formula_indicator_rules.png	16K

Welcome!

Categories

Ideas Parade