Formula Calculation Not being done

[Akshaya]

Hi All,

Greetings!

So this time I  am facing issue with the formula which is not giving the output, instead its just displaying 0.

The formula that I am using here is as below:

=(((Sum({<REC_TYPE={InvoiceDateRec}>} (RAGLDA_ACCTD_AMOUNT*XRATE_CONST*RATE))/num(SUM({<REC_TYPE={InvoiceDateRec}>} ARCOST_PRIMARY_QUANTITY),'#,##0.00'))
-
Sum({< Modified_Date={">=$(=ADDMONTHS(MAX(Modified_Date), -12))<=$(=MAX(Modified_Date))"},
REC_TYPE={InvoiceDateRec}>} (RAGLDA_ACCTD_AMOUNT*XRATE_CONST*RATE))/Sum({< Modified_Date={">=$(=ADDMONTHS(MAX(Modified_Date), -12))<=$(=MAX(Modified_Date))"},
REC_TYPE={InvoiceDateRec}>} (ARCOST_PRIMARY_QUANTITY)))
*
num(SUM({<REC_TYPE={InvoiceDateRec}>} ARCOST_PRIMARY_QUANTITY))) /3

Overview of the formula is:

Calculation:
(Invoice Actual(CC)/Invoice Primary UOM Quantity)-TTM price *Invoice Primary UOM Quantity/3

(Above formula is in this same sequence)

Not sure what is going wrong here...but all the formulas that are combined and being used for this calculation  are being calculated properly and getting output also.

Say the 1st column 'TTM Price'(Please see Screenshot) is giving me the value, and formula that i have used for that is as below, and is also a part of the second column 'Estimated Impact (TTM Price)', as highlighted in the above formula.

Please advise what i am doing wrong here.

@GeorgePhilips23 @MayilVahanan  @durgesh22 @rwunderlich 
@Qlik3 

Thankyou very much in advance!

Akshaya 

[MayilVahanan]

HI Akshaya,

Might be, due to date format

Sum({< Modified_Date={">=$(=Date(ADDMONTHS(MAX(Modified_Date), -12)))<=$(=Date(MAX(Modified_Date)))"},
REC_TYPE={InvoiceDateRec}>} (RAGLDA_ACCTD_AMOUNT*XRATE_CONST*RATE))/Sum({< Modified_Date={">=$(=Date(ADDMONTHS(MAX(Modified_Date), -12)))<=$(=Date(MAX(Modified_Date)))"},
REC_TYPE={InvoiceDateRec}>} (ARCOST_PRIMARY_QUANTITY)))

If not, pls post the same file..  Modified_Date is date format or in text format?

Its blank here.

[GeorgePhilips23]

It would be easy to verify formulas if you can post sample data.