Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi.
If(value>1, 'Excess', If(value=1, 'Onlevel', 'Depreciation'))) as ListValues
Is that what you want ?
Hi.
If(value>1, 'Excess', If(value=1, 'Onlevel', 'Depreciation'))) as ListValues
Is that what you want ?
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
Could you provide a sample file or at least your load script where you've used the above string ?