Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
this is the condition in EXcel
if(ZYME<=CDMS,(ZYME/CDMS)+100%,(ZYME-CDMS)/ZYME)
in this how can write in qlikview front end
Specially 100% how can i calculate it
Regards,
Mahesh
Write like this:
if(ZYME<=CDMS,(ZYME/CDMS)+1,(ZYME-CDMS)/ZYME)
And then in the Properties:
Can you please share some sample data along with the expected output...
Hi Bro ,
I am doing this is this correct
if(ZYME<=CDMS,(ZYME/CDMS)+'#,##0',(ZYME-CDMS)/ZYME)
Hi
CDMS ZYME
10 15
15 10
15 15
Regards,
Mahesh
if(ZYME<=CDMS,(ZYME/CDMS)+'#,##0',(ZYME-CDMS)/ZYME)
Write instead:
if(ZYME<=CDMS,(ZYME/CDMS)+1,(ZYME-CDMS)/ZYME)
Hi Bro your Condition showing Wrote %
I given Sample data please check once
its showing 200%
pls find this file
May be something like below: