SI.TURNOVER Location Group?

Ideas & Feature Requests
1

Howdy,

Feature request here.

It would be great to specify a location group in the LocationId parameter of the SI.TURNOVER function.

Currently we can specify multiple comma separated entities/locations, so using a location group doesn’t seem to be much different.

Thanks

Ben

2

Hi Ben,

Given that Location is just another dimension, you also have the ability to filter on it and leverage our support for dimension groups in the Dimensions argument of the function:

1872×712 194 KB

The exact formula I used is

=SI.CLOSINGBALANCE(“Sage”,“1???”,“2019-01-01”,“2019-12-31”,SI.DIMENSIONS(“Sage”,“Location Group”,C2))

3

Hi Gabriel,

Will this still work if we have multiple base currencies?
The docs say the LocationId parameter for SI.TURNOVER is Optional unless the company has multiple base currencies

Do I just leave the parameter empty and use the Location Group Dimension as you said?

Thanks
Ben

4

Yes, just leave it empty and filter using the Location Group dimension. The instance I tested it on in my previous message has multiple currencies enabled, Location ID was left blank and I got the balance for the “Operation Locations” location group.