Formula Calculation Not being done

Akshaya — Mon, 25 Apr 2022 16:26:06 GMT

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

Re: Formula Calculation Not being done

MayilVahanan — Mon, 25 Apr 2022 21:49:55 GMT

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.

Re: Formula Calculation Not being done

GeorgePhilips23 — Tue, 26 Apr 2022 05:59:01 GMT

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

topic Re: Formula Calculation Not being done in App Development

Formula Calculation Not being done

Re: Formula Calculation Not being done

Re: Formula Calculation Not being done