Hi guys!
I’m having trouble with my excel formulas calculating KNIME generated data.
My excel formula seems to be working when the date is manually typed but it wont trigger when the data is produced by KNIME
in my photo:
2nd row of data column R is manually typed
3rd row column R is KNIME Generated
this is the formula to my column AA
=IFERROR(IF((AA$4-$U7)/30>$Q7,0,IF($R7<=AA$4,IF($R7=AA$4,($Y7*(DATEDIF($U7,$R7,“m”)+1)),$Y7),0)),“”)
my writer node is Write to excel template and I already ticked the recalculate all formulas box on the configuration.
if i cannot replicate the typed data, can I translate the formula into knime as well?
any easier solution would be helpful
thank you!