help with a conditional statement
Hello,
I wrote a simple formula for Wip Rev that checks the amount in Earned Revenue (that is calculated too) and calculates the difference between its current value(POV) and prior year end value(...
Forum Discussion
I would first attempt to copy what is A#EARNED_REVENUE to the A#REVENUE_WIP2 account to make sure populating value into A#REVENUE_WIP2 is working without any condition. The reason for this is because I want you to make sure the source A#EARNED_REVENUE has a value to copy in the first place, as you said this is also calculated account.
Regarding dynamic calc on A#REVENUE_WIP2 may work as that is executed only when used in the presentation layer.
I am advising you to set the correct formula pass number such A#EARNED_REVENUE runs in a pass earlier than A#REVENUE_WIP2.
On other note, you don't need OnEvalDataBuffer as you are not using any filtering logic on the sourcedata buffer.
Thank you for looking at this. If I remove the conditional statement then formula works, but the reason it is there in the first place is so we don't have a negative amount in Revenue_WIP , because it means that given job closed and negative revenue doesn't represent any value.
Also, I keep this test in the development and make sure that Revenue Earned has the data or not to see results based on the conditional statement.
Formula passes seem fine to:. Rev Earned is pass 2 and Rev Wip pass 4.
Does it matter that Revenue_Earned is a balance account and Revenue WIP is set as revenue? I am not sure what else to look at.
Thank you again for looking at this and to your point removed OnEvalDataBuffer as you suggested - I copied it from the Golf app.
thank you,
Ola