Status

[kalyandg]

Dear All,

               I have a issue in status for excess, onlevel and depreciation, while i select excess from drop down list, it should about 100%, i know that we can solve this using visual cues, but i need to do this in script.

for excess i have to give a condition that value which is >1 ----- 'Excess'

for onlevel =1 ----------------- 'Onlevel'

for depreciation <1 ------------------ 'Depreciation'

  Please help me to solve this issue, Excess(more than 100%), onlevel(100%) and depreciation(less than 100%)   

Thanks in Advance,

Kalyan.D  

[whiteline · Accepted solution]

Hi.

If(value>1, 'Excess', If(value=1, 'Onlevel', 'Depreciation'))) as ListValues

Is that what you want ?

[kalyandg]

hi white,

the expression you have replied is correct, but for me it showing less than and more than 100% values when i select onlevel, i dont know what is the problem. please help.

Thanks,

Kalyan

[whiteline]

Could you provide a sample file or at least your load script where you've used the above string ?