I would like to add the following function to the report
In the TCR column I would like to calculate the TCR percentage, but it we use solid SPT(SPT/C) then I would like the TCR value become - N/A
So my equation so far:
<<IIf(<<METHOD.Description>><>"SPT/C",_<<Format(<<CALC((<<METHOD.Recovery>>/(<<METHOD.Bottom>>-<<METHOD.Depth>>))*100)>>,"#")>>)>>
But when Method.Description=SPT/C, I would like to give the command to write N/A...
How can I write this command and how can I link them together?
Many thanks...
Thank you!! It's working....YAY! :)))
You are so close!
The IIf clause has an optional "if not true" argument that follows the argument when the conditional is true. So your expression:
<<IIf(<<METHOD.Description>><>"SPT/C",_ <<Format(<<CALC((<<METHOD.Recovery>>/(<<METHOD.Bottom>>-<<METHOD.Depth>>))*100)>>,"#")>>_)>>
of the form
<<IIf(conditional expression,return value if true)>>
could be modified to the form
<<IIf(conditional expression,return value if true,return value if false)>>
by adding the "N/A" value to be returned when <<METHOD.Description>> = "SPT/C (in other words, when <<METHOD.Description>><>"SPT/C" is not true):
<<IIf(<<METHOD.Description>><>"SPT/C",_ <<Format(<<CALC((<<METHOD.Recovery>>/(<<METHOD.Bottom>>-<<METHOD.Depth>>))*100)>>,"#")>>,_ N/A_)>>