Share
ReportI have been following the Repeating Tables video from Shane Young. In Part 2, there is an edit section to update cost back to SharePoint.
My issue is that the original cost entered earlier when the record was first created, used a calculation.
So in the Part 2 of the video, if I change the cost in that field, it is not being calcalated based on another field like the original entry. I have tried the similiar formula to fix it but that did not work.
In the above image, If the value of TravelDay is Yes, then the Per Diem Rate is multiplied by .75, otherwise the value is the Per Diem Rate.
In the original entry, the forumula is:
If(
Value(ThisItem.PerDiemRate) <> 0 && ThisItem.TravelDay="Yes",
Value(ThisItem.PerDiemRate) * .75,
Value(ThisItem.PerDiemRate)
)
But since this Edit version comes directly from SharePoint, I cannot get a similiar formula to work.
Suggestions?
All responses (
Answers (
296
