Hi Shin, Thank you for reply. But my requirement may not be just to verify the value NULL or not.!! May be I am bad in explaining in first post, Pl let me know if the below lines helps to explains more..
If 'Version C' exists for selected Year, then Use Version C Else Use version B--- To compare against Version A values.
Generally my users will load Version B values in January month,
After initial review, for ex: in month of Mar or April, they will load Version C values in Database
So, when there is no 'Version C' data for current year, then I need to use Version B values, After 'Version C' load complete, I need to use them.
Users do not want to see a filter or parameter to select which version they want ( B or C)
Thank you in Advance.
Testdata.xlsx 10.2 KB
Thank you for quick reply, thinking reality, always version B name is -- "Budget" , Version C name would be current month like ( Feb or April or Nov)
there would be a scenario where Version C value of 2018 may be blank for specific month, But Version C exists for other months, then we need to use Version C as data for Version C is loaded.
Without being provided whole the possible logic, it's difficult to think out the absolute solutions.
Could you please clarify the whole logic again.
Dataset would be : Date, Version, Value
Values for Version will be -- Actual, Budget, AAA-Forecast (AAA would be 3 chars of month)
When user selects Year as a filter, if AAA-Forecast version available for at least one row of that year, then show AAA-Forecast values.
Could you attach sample data?
The logic is still unclear. Which forecast of month do you use for specific year if you have multiple AAA-Forecast in one year?
Or if there are no AAA-forecast on specific month, what do you want to show?
if AAA-Forecast version available for at least one row of that year, then show AAA-Forecast values.
I am confused with year and month with users filtering.
We will have only one AAA-Forecast values ( we will replace if we have another version). Users will only have year filter,
If there is no AAA-Forecast for selected Year, then we need to use Budget values.
Selection of Budget or AAA-Forecast is purely depending on AAA-Forecast exists at least one row for that year or not..!!
I'm sorry I still don't understand fully.
Could you please attach couple of sample data with expected results.
Budget version will be loaded by start of every year.
I need to compare against Actual -- either Budget or FCST (based on data existence)
For Selected Year,
Distinct of (Version)
If AAA-Forecast exists use AAA Forecast