Requirement to convert & save

[Former Member]

Hello,

I have a client requirement where there is an input form with accounts & entities in row axis.(Zero suppression on). Now the client will enter values in meters, and the requirement is within worksheet I should be able to convert that data into miles and send to accounts. Both meters and miles have separate accounts. Users shouldnt be able to see miles accounts.

What i have tried so far:

I have tried creating local member that attaches itself to each row, and sends data using epmsave. However user doesnt like it as it shows the local member row after each row. users dont want to see it.

Thanks.

[former_member186338 · Accepted solution]

"Users shouldnt be able to see miles accounts" - then just create a simple script logic in default.lgf like

*WHEN ACCOUNT

*IS MeterAcc

*REC(EXPRESSION=%VALUE%/1609, ACCOUNT=MileAccount)

*ENDWHEN

Vadim

Corrected

[Former Member · Accepted solution]

Client doesnt want script logic, I just created another input form to solve this. thanks.

[Former Member]

Hi Manny,

Just hide the local member row, or alternatively remove the local member, create a hidden table beside your report, and do all the conversion there, then use epmsavedata to save to the correct intersection.

Andy