Retail Predictive Application Server (MOSC)

MOSC Banner

MFP RETAIL Release 15.0 - Calculation SALES R & SALES NET VAT R

edited May 19, 2017 5:04AM in Retail Predictive Application Server (MOSC) 1 commentAnswered

Hi,

I'm analyzing the module MFP RETAIL release 15.0, looking into the workbook "Develop and publish Company Target (task Preseason Create MFP)" there is a strange relationship calculation between the Measure Sales R (TDWpSlsR) and Sales net Vat R (TDWpSlsNetR).

CASE n. 1 (see screenshot attached): Inserting manually previously the Sales R and then click on calc -> the measure Sales net Vat R is lower than Sales R and it's calculated with the formula TDWpSlsNetR = TDWpSlsR / (1+  BUWpVATp)

CASE n. 2 (see screenshot attached): Inserting manually previously the Sales net Vat R and then click on calc -> the measure Sales R should be higher then Sales net Vat R (but i see Sales R with lowest value) and it's calculated with the formula TDWpSlsR = TDWpSlsNetR * ( 1- BUWpVATp).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center