SI.TURNOVER Location Group?

Posted 1 day 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

2 Comments

Ben Perry posted about 6 hours 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 about 19 hours 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