Level 3 Sprint 1 - 5.2 PY Account Revenue

KonstantinGrishachev
Occasional Contributor

Level 3 Sprint 1 - 5.2 PY Account Revenue

Hello All,

 

I have stuck with formula for 'PY Account Revenue' in 'TAR01 Detailed Sales Targets'.

Looks like formula:
'DAT02 PY Revenue to CY'.PY Sales Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account']
is not correct, because I have incorrect numbers in Check module.

 

Can anyone help with correct formula for that item?

 

KonstantinGrishachev_0-1591195155791.png

KonstantinGrishachev_1-1591195202788.png

 

 

10 REPLIES 10
klameer
Occasional Contributor

Thanks @KonstantinGrishachev this was really helpful.