ADD_DAYS(KPI(BLINE_DATE),KPI(CATEGORY_VENDOR_TERMS_DAYS))
where KPI(CATEGORY_VENDOR_TERMS_DAYS) = GREATEST(KPI(INVOICE_TERMS_DAYS),KPI(REG_VENDOR_TERM_DAYS)).
The output of above KPIs is days only in INT value. Not sure why this error is showing up.
Page 1 / 1
Hi Ankita,
it seems that KPI(CATEGORY_VENDOR_TERMS_DAYS) is somehow in FLOAT. Can you try to put TO_INT(KPI(CATEGORY_VENDOR_TERMS_DAYS)) and see if this works?
Hi, I am trying to do the exact same thing. I tried the TO_INT function and I am being given the error that TO_INT is not compatible with FLOAT. I thought the whole point of the TO_INT function was to convert float to integer. 
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.