I am a new user to Bus Obj and have created a cross tab table with data in rows and colmns. I want to introduce a variane column after each Period showing the + or - variance.
The syntax I use in the main body of the tables doesn’t work in the “Totals” row .
The syntax i have used to populate the main body is given below
=Count([Output No]) Where( [Updated At] < (RelativeDate([Period End Date];12)) Or (IsNull([Updated At]) And ( [Output Created On] < (RelativeDate([Period End Date];12))))) - Previous(Count([Output No]) Where( [Updated At] < (RelativeDate([Period End Date];12)) Or (IsNull([Updated At]) And ( [Output Created On] < (RelativeDate([Period End Date];12))))))
Where clauses in aggregates must be followed by a boolean statement - Where ([Colour] = “Red”) for example. You will need to create a variable to wrap up your logic into a 1 / 0 flag so that you get a simple statement like:
