How can I merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year
Smarten - Solution Team
started a topic
about 3 years ago
How can I merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year as per the below scenario from the attached files?
Scenario:
Projection – Plan sales data is in Calendar year, monthly data.
Actual sales data is in financial year, monthly data.
Smarten - Solution Team
How can I merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year as per the below scenario from the attached files?
Scenario:
Projection – Plan sales data is in Calendar year, monthly data.
Actual sales data is in financial year, monthly data.
Please refer to the below knowledge base
http://support.smarten.com/support/discussions/topics/9000056177
Smarten - Solution Team
Please refer to the below knowledge base
http://support.smarten.com/support/discussions/topics/9000056177
-
How do I choose only required columns while creating a dataset with step by step wizard from any database
-
How do I select only the required columns after creating the dataset.
-
If we have join/union in the dataset then do we have to refresh the main dataset every time after i do any changes in the child(Join/Union) dataset.
-
How to convert timestamp based text formats to Timestamp
-
I'm Unable to display graph with financial month values (that starts from April)
-
How can I count day wise new addition of counts from the data with day wise closing balance of counts?
-
How can I apply rounding logic to time data – e.g. 1:39 PM should be 2 PM and 1:20 PM should be 1 PM.
-
Dataset Action Editor – Action item status (active or inactive) is not saved permanently
-
How can I create a dataset using stored procedures in RDBMS instead of a query?
See all 13 topics