Getting blanks after applying the correct formular

Adejimi
Contributor

Getting blanks after applying the correct formular

Hi Team,

 

After applying the formular as required.

 

My screenshot shows zero.

 

Can you guide me as to what I am missing.

 

screenshot below refers

 

Adejimi_0-1657780211631.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoRodriguez
Regular Contributor

Hello @Adejimi ,

 

What about the LI you used for the lookup? In SYS08, check Department and Role. Are those blank?

 

Cheers!

Best,
Bruno Rodriguez

View solution in original post

7 REPLIES 7
BrunoRodriguez
Regular Contributor

Hello Adejimi,

 

I believe the reason for the blanks is that you are looking at the department (i.e., Finance) rather than each of the specific employees. As you can see, all that data is date or booleans do not likely have a summary in the blueprint or cannot be summarised.

 

Hope that helped!

Best,
Bruno Rodriguez
Adejimi
Contributor

Hi Bruno,

I did the same for a specific employee and got the same result.

 

please see below.

 

Adejimi_0-1657781487627.png

 

 

Any further help?

BrunoRodriguez
Regular Contributor

Hello @Adejimi,

 

Ok, now I get you. Have you checked that your Bonus % is different from 0? It looks like you salary is there, but it may have been multiplied by a number that is 0. Alternatively, the lookup could have worked, but the line items that you used for the lookup could be blank and you need to populate them.

 

Please let me know how you get with the above.

Best,
Bruno Rodriguez
Adejimi
Contributor

Hi,

 

The bonus % is not 0.

 

Adejimi_0-1657781957938.png

 

Checking through the line item and not seeing any zero either.

 

Any other suggestions?

 

 

 

BrunoRodriguez
Regular Contributor

Hello @Adejimi ,

 

What about the LI you used for the lookup? In SYS08, check Department and Role. Are those blank?

 

Cheers!

Best,
Bruno Rodriguez
Adejimi
Contributor

Hi Bruno,

 

You rock.

 

So Roles were blank. Repopulated it and viola, got fixed.

 

Thanks once again.

BrunoRodriguez
Regular Contributor

Hello @Adejimi ,

 

No worries, happy to help! When data is blank or 0 is generally because something is odd downstream. Either those items or the summary of a LI not being as it should.

 

All the best!!

Best,
Bruno Rodriguez