difference between average and time sum function ?
Sum function will aggregate the data whereas AVERAGE function will take the average.
For example in above screenshot, right side in total Salary line item we are taking SUM of Salary by Country, so for IND it is showing 600 (100+200+300) whereas for Avg Salary line item it shows the average salary by Country i.e. 200 (600/3).
@divyanshsharma timesum aggregates the value between two periods .https://help.anaplan.com/timesum-45c3bc48-4d80-490d-9b18-76af505c6907
TIMESUM function aggregates the data from a line item with time dimension to a line item without time dimension. Whereas average function takes the average as mentioned in my comment above.
Hi
@divyanshsharma
Average is just Sum of records divided with No.of Records where as Timesum is considered to sum specific data dimensioned by time with defined/optional start and end periods
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
