question

Ketan-7786 avatar image
0 Votes"
Ketan-7786 asked RobCaplan edited

Validations for differnt field in excel

How to validate below item

There is column in spreadsheet ParentItem Number(parent) , and Child Item (children) based on that i need to validate data

1 A validation will be displayed if the sum of the parent/children is less than 1.00 for both values for Plan fact column
2 A validation will be displayed if the sum of the effective parent/children is more than 1.00 for Roll Fact column
3 An validation will be displayed if the sum of the Parent Roll-up Factor of the e parent/children is greater than 1.00.

in c #

please have look into attached screenshot

73032-image.png


dotnet-csharpdotnet-runtime
image.png (14.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers