Report using Recursive Calculated Fields

[Dariussiriuse]

Hi everyone!
I'm trying to report on a field that is recursively calculated on the form, but it shows me 0 across the entire line...

I have a record with some expenses, referenced by two other tables with other expenses. The main one should be basically an addition of the two other tables associated with it. 

And so I know that it works, because on the record, I get the right number.

But then on the report, it just shows 0?

Can anyone help me show the right data?

Many thanks
Darius

[AshishKM · Accepted solution]

Hi @Dariussiriuse , 

There must be some logic, calculting the field value onLoad and showing on form but not storing ( Save) in record.

So when you are trying report that calculation is not triggering. 

You can check if that field has some value in ListView and Form both.

-Thanks,
AshishKM

[Dariussiriuse]

Hi @AshishKM 
Well, it does show in the list view as holding a value actually 😕

[Dariussiriuse]

Actually, you know what?
You're right. Well, more like it will display it on load both on form and list, but doesn't actually updates it. 

But if I do save this record as it loads, the value gets saved as well.

I'll give you the point.

[AshishKM]

that makes valid point, once you save the record, field value also saved and display in report.