Dear Experts, As you can see, in the picture I have opened an account of shop expenses, and see That closing balance below in Words Format, so same as this, I want if I select one of any entry, then its balance should be seen in words in Below, SEE THE CODE BELOW [#Line: DSP VchClAmt] Add : Left Field : ClBalinWord [#Line: LV FCThree] Add : Left Field : ClBalinWord [Field: ClBalinWord] Set as: $$InWords@VchClg + @@IfAmtthenOnlystring Add :Background : Blue Add :Color : Lily White Add :Border :Thin Box Local:StyleEFAULT:Height:17 [System: Formulae] IfAmtthenOnlystring : If @@VchClg = 0 Then "" Else $$String:" Only" SEE THE SCREENSHOT BELOW
IMAGE NO. 2 When I select any of Entry So Showing Below That Perticuler Entry Balance in Amount In word Format
[#Line: DSP VchClAmt] Add : Left Field : ClBalinWord [#Line: LV FCThree] Add : Left Field : ClBalinWord [Field: ClBalinWord] Set as: If $$IsEmpty@VchClg Then "" Else $$InWords@VchClg;@@IfAmtthenOnlystring Add :Background : Blue Add :Color : Lily White Add :Border :Thin Box Local:StyleEFAULT:Height:17 [System: Formulae] IfAmtthenOnlystring : If @@VchClg = 0 Then "" Else $$String:" Only"
Try this as a first step...... [#Line: DSP VchClAmt] Add : Left Field : ClBalinWord [#Line: LV FCThree] Add : Left Field : ClBalinWord [Field: ClBalinWord] Set as: $$InWords@DispAmt + @@IfAmtthenOnlystring Add :Background : Blue Add :Color : Lily White Add :Border :Thin Box Local:StyleEFAULT:Height:17 [System: Formulae] DispAmt : if $$IsEmpty:#DSPVchDrAmt then #DSPVchCrAmt else #DSPVchDrAmt IfAmtthenOnlystring : If @@DispAmt = 0 Then "" Else $$String:" Only" This will provide you balance of the first entry. All you have to do is now add logic form showing it for selected entry. enjoy learning.