Tables pdf No Border on Tables /Iterations/Recalculation Formulaes

benjamin · January 21, 2011 2:24PM

Hi

1.When i export a tab to pdf, currently the permiter line (border) of the table does not show up.The border for the inner cells shows up but not the outer border of the table.Why is this ?

2.I would like to do an iteration (loop) on a calculated column, but currently omniscope says it does not allow circular references.Will this be possible in the future ?

E.g

Say i have Column1 with Colours RED/GREEN/YELLOW and each row is a different date Say March,April,May,June etc .I would like to count for each date how many consecutive dates (Start at 1 for Current Date) previously have that same colour.I would like to calculate the column "output" using a loop

Eg Assume Data set

Date Column 1 Output
Row 1 Jan RED 1
Row 2 Feb RED 2
Row 3 Mar RED 3
Row 4 Jun GREEN 1
Row 5 Jul YELLOW 1
Row 6 Aug YELLOW 2
Row 7 Sept GREEN 1
Row 8 Oct RED 1
Row 9 Nov RED 2

I have found a way around this by introducing IsGreen,IsRed adn IsYellow coloumns (1 if it si colour and 0 if not )and then doing a subset max of Dates over all records with IsColour=0, and Dates

steve · January 25, 2011 2:51AM

1. This sounds like a fault - we'll investigate. You may possibly be able to work around it by adjusting the print margins or the export to PDF options (a series of tickboxes controlling the appearance).

2. In Omniscope 2.6, you can use an operator in the SUBSET function. For example:
RECORDCOUNT(SUBSET([Month number], "<="))<br />
See http://www.visokio.com/kb/subset-functions

In this case you would also want to define another formula field "Month number" which converts your date (in your example, just a Month) to a numeric value:

If it's a text field, first convert it to a date:
TEXTTODATE([Column 1], "MMM")
then convert the date to a month number:
NUMVALUE(DATETOTEXT(..., "M"))

Does this work?

mustafa · January 27, 2011 8:54AM

The problem 1 you mentioned was actually a bug with Omniscope which has been fixed. The fix will be available from tonight's release 2.6 b504.

Welcome!

Categories

Ideas Parade