lvs
LVS (Last Value Sum) is a function that you can use to create a formula that gets the sum of the last registered values from a number of organizations when using an AGG function. It is similar to the LV function that gets the last registered value, independent of organization.
This function will only have meaning if placed in an AGG function.
Syntax
AGG('LVS[100]')
Use
Use LVS if you have 2 organizations where Organization1 has the value 10 registered in January and Organization2 has the value 8 registered in February, and you want to get the sum of both values (10+8) instead of just the last registered (Organization2) as is the case with the LV.
AGG('LVS[100]',100,101)
How to create
In the Function Calculator, click the AGG button. Highlight the node you want to use and click the LV button and choose LVS. Click OK and the complete the AGG function in the usual way.
