Skip to Content
Technical Articles
Author's profile photo Xavier Le Garrec

Building an override from a lookup table with 0 as an accepted value

Introduction

When building override options for customers in Variable Pay or Compensation it is better to build them through lookup tables or MDF objects so that in case worksheets get deleted and relaunched Comp Admin doesn’t lose any data already entered on screen.

 

Solution

In this particular business case we look at how to build an override section where 0 is an accepted value which was harder to build than I first thought due to system limitations when building formulas referencing other fields calling lookup tables in them.

 

 

 

All the best,

Xavier

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Amit Zamader
      Amit Zamader

      Thanks for sharing the step-by-step details,