Formula is not seeing the fields in the same data source

Good day

Just started with NocoBase v1.8.22, I have a problem where i want a simple calculation in two fields example, i Have a Subscription page with coulombs cost (Number Interface), quantity (Integer) and total cost (Formula).

Cost formula is cost * quantity

But the field stays at 0.00.

On another Data source (Assets) and Asset page. I need to calculate age totdate from another column. Example Column Posting date and current age. current age must show the age calculation from posting date to now.

Formula for Age is: concat(
date_diff(“year”, asset, now()), " years “,
mod(date_diff(“month”, asset, now()), 12), " months”
)

But it stays blank, it seems the fields cant get the information from other fields?

I.m. lost here… any help would be appreciated.

Hope this makes sense.

Regards

To help us troubleshoot this more accurately, could you please take a screenshot of your field configurations and formula settings? This will make it easier for us to see where the issue might be.

Hi,

Sure no problem. 1 - 3 is for the asset block not updating and 4-6 is the total cost not updating.