Use Multiple Dim property value in script logic
I have one requirement, there is two input schedule both input schedule are almost same. Where input schedule 1 is user input and input schedule 2 has a one special features user want A deletion column is available in the input form2 to enable planner to remove records in the system. If deletion value of the record is marked with ‘Y’, the record will be removed from the system and no costs will be calculated for the record when form is saved.For that i use if condition in column H,but the logic will overtire the total value not in any particular cell.I want the script will execute for specific cell not whole report.
Is there any way to achieved this.
Vadim Kalinin replied
Property value is a part of master data and you can't change it using input form to enter transactional data (I will not discuss here Master Data on the Fly).
You can use some extra account and for example store value 1 to this account to clear other accounts.
Example: New account - testacc
*REC(EXPRESSION=(testacc==1) ? 0 : [ACCOUNT].[bankkpi2], ACCOUNT=bankkpi2)
*REC(EXPRESSION=(testacc==1) ? 0 : [ACCOUNT].[bankkpi3], ACCOUNT=bankkpi3)
*REC(EXPRESSION=(testacc==1) ? 0 : [ACCOUNT].[bankkpi4], ACCOUNT=bankkpi4)