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
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.
