Skip to Content
avatar image
Former Member

DS Cross Data validation

Hi Experts,

we have created an design studio for planning process. Now we need to make an alert to users when they have entered a data like below scenario.

Eg: As per below scenario the value for 2017 always need to be lesser than value of 2016. so if they have entered an value higher than 2016 then a formatting like red background need to be appear. else we can also check the data while saving.

Please provide your suggestions to achieve this.

Regards,

Ramesh Jothimani

9mk6q.png (3.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 18, 2016 at 10:17 AM

    Hi Tammy,

    Thanks for the reply.

    I forgot to inform that I am using the version 1.5 only, I am not sure how we can achieve this in version.

    and the BEx exception could help to check whether the measure support a condition based on some static value not based on other measure. Please let me know If I am wrong.

    Thanks!

    Regards,

    Ramesh Jothimani

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2016 at 09:56 AM

    Have you tried using conditional formatting for Design Studio? Or even in the BEx Query (exceptions)? See my search link: http://bfy.tw/8pzI

    Add comment
    10|10000 characters needed characters exceeded