SI.TURNOVER Location Group?

Posted 2 days ago by Ben Perry

Post a topic

Ben Perry

0 Votes

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

0 Votes

3 Comments

Gabriel Michaud posted about 15 hours ago

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.

0 Votes

Ben Perry posted 1 day ago

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

0 Votes

Gabriel Michaud posted 1 day ago

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:

The exact formula I used is

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

0 Votes