Hi All,
Im not having much luck with this - Ive tried DVar but maybe Im not understanding the function correctly.
I have a crosstab query that will only ever return 2 columns of data (sales for the current month and the previous month).
I want to add a column that will show the variance between these 2 columns. I can add a 'Total' column but can I add a variance column?
If not a built in function does anyone know of a custom function?
Many thanks
Im not having much luck with this - Ive tried DVar but maybe Im not understanding the function correctly.
I have a crosstab query that will only ever return 2 columns of data (sales for the current month and the previous month).
I want to add a column that will show the variance between these 2 columns. I can add a 'Total' column but can I add a variance column?
If not a built in function does anyone know of a custom function?
Many thanks