SAC Advance Planning - Account Dimension Calculation

[SANA11]

Hey all, 

Can anyone help me with getting the calculated North America Revenue to appear in Calculated Gross Sales for the Forecast Version?

The issue I’m facing:

When I use a simple IF statement on Units, the values appear correctly.
However, when I apply a LOOKUP formula and then use an IF statement, the values disappear.
Even if I try to directly display the Stored Price (which is fetched using LOOKUP), the values do not show up.

DRV0050 = Stored Price
DRV0020 = Units

H111100 = Gross Sales 

DRV0055 Lookup Price (NA) = LOOKUP([DRV0050] ,[d/ENTITY]="#" )
- Since price for each product for all US regions stored under entity #
DRV0060 Revenue (NA) = [DRV0020]*[DRV0055]

IF([d/VERSION].[p/CATEGORY]="Actuals" ,[H111100] ,
IF([d/ENTITY].[p/ENTITY_H1L2]="United States" ,[DRV0060] ,[DRV0080]))

[William_Yu · Accepted solution]

'Calc Gross Sales' is having scaling of M, while the 'Lookup price' is only 2.8k, probably it's only a problem of scaling. Try to remove the format. 

[SANA11 · Accepted solution]

thank you william_yu for assistance issue resolved

[SANA11 · Accepted solution]

got it thanks