Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Below expression works fine in the text object and shows value properly
=((If(IsNull(Max({$<Year={$(=Max(Year))}>} per)),Week(Now()),
Pick(Match(Max({$<Year={$(=Max(Year))}>}per),
1,2,3,4,5,6,7,8,9,10,11,12),
4,8,13,17,21,26,30,34,39,43,47,52
)
)
))
But when i'm assigning expression in button action for Set Variable, then if i click button for twice then the proper value is getting:
Variable --> vCYMaxWeek
Value --> =((If(IsNull(Max({$<Year={$(=Max(Year))}>} per)),Week(Now()),
Pick(Match(Max({$<Year={$(=Max(Year))}>}per),
1,2,3,4,5,6,7,8,9,10,11,12),
4,8,13,17,21,26,30,34,39,43,47,52
)
)
))
Post your experience on this issue.
Thanks in advance
May be there might be two or multiple values of the expression ?
Plz share a sample
Hi Satish,
I don't quite understand: That expression looks good, but where does that variable vCYMaxWeek come into play? How should that influence the formula?
=> From the look of it, you have a field > per < that can take the values 1 through 12 or BLANK and depending on that, you generate another field. Right?
Please explain in a little more detail what your issue is. Crystal balls are so hard to come by these days ...
Also, like Albert Einstein already stated "The detailed description of a problem often leads to a solution". This was repeated by Feynman who got the Nobelprice for it, I think, and it does happen to be true ...
Best regards,
DataNibbler
Hi please find my sample attached app.
thanks in advance.