Forum Stats

  • 3,839,636 Users
  • 2,262,517 Discussions
  • 7,901,025 Comments

Discussions

Check report Validation for 2 scenario's

Hi Gurus,

I have a scenario to modify the check report, as given below.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------

Entity     | Description                | Actual~1  Data    |  Actual~2   Data   |   (Actual~1 data) - (Actual~2 data)

--------------------------------------------------------------------------------------------------------------------------------------------------------------------

1234       | Assets                      | 1000                  | 1000                    |                   0

4321       | Liability                     | 5000                  | 2000                    |                 3000

--------------------------------------------------------------------------------------------------------------------------------------------------------------------

Questions

  1. Can we able to pull the data using the validation rule, other than active scenario for the location. because only one scenario will be activle for that location.
  2. and if the report is working fine, what script in FDM should i modify to stop data load, if the validation fail (eg:- CHECK report shows fail for Assets)
  3. Can i concatenate this underlined display below result display section in the report, with another account for same POV. is it possible? can you give an code sample.

Example validation rule:-

'Fun:

If Abs(|Actual~1,,,,,,123456,[ICP TOP],TotalCustom1,TotalCustom2,TotalCustom3,TotalCustom4,,,,,,,,,,,,,,,,| - |,-1,,,,,123456,[ICP TOP],TotalCustom1,TotalCustom2,TotalCustom3,TotalCustom4,,,,,,,,,,,,,,,,|) > 0  Then

  RESULT = True

  RES.PblnCheckWarning = True

  RES.PstrCheckMessage1 = "Account 123456 should not change from prior month"

  RES.PstrCheckMessage2 = "Please provide explanation."

Else

  RESULT = True

End If;

(|Actual~2,,,,,,123456,[ICP TOP],TotalCustom1,TotalCustom2,TotalCustom3,TotalCustom4,,,,,,,,,,,,,,,,| - |,-1,,,,,123456,[ICP TOP],TotalCustom1,TotalCustom2,TotalCustom3,TotalCustom4,,,,,,,,,,,,,,,,|)

with regards

Kathir

Tagged:
This discussion has been closed.