Dear All,
I have to following requirement, in the real time cube we have the plan and actual data and I want to stamp the reason against the record.
If (actual >= plan) then
Reason = plan meet.
Else
Reason = Plan Not Meet
End if.
Material Reason Plan Qty Actual
cnree100 PlanMeet 10 18
pawa100 Plan Not Meet 23 20
chris100 PlanMeet 454 460
How to read record by record and update the reason for the given filter
How to achieve these using IP u2013 Fox formula.
How to fetch plan qty and actual qty in in Fox Formula.
Thanks
Christopher