Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one report in that i have calculated column say suppose "Output" (Column 35 ) and it is being calculated by (((Column(25))/Column(26))*Column(10))
In Output column i am getting some Null ( - ) values .
My expected output is instead of this Null ( - ) I want Column(10) else (((Column(25))/Column(26))*Column(10))
Thanks
PM
May be this
Alt((((Column(25))/Column(26))*Column(10)), Column(10))
Not sure why you removed your response, but here is the explanation
Alt function picks the first non-null value in the order of expressions... so when (((Column(25))/Column(26))*Column(10)) is null, it picks Column(10)
Sorry it was by mistakenly deleted... In that I have written "Thanks Sunny.. Please explain little bit. "