Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need help with variable.
I have Field Month with values in format like this:
Month
01
02
03
I have defined variable:
vmaxmonth=Max(Month)
But result of vmaxmonth in set analysis or text object is not 03, but 3.
Hi,
This depends on what data format you have in Month field.
If it is a Text then you should use the Maxstring instead of Max function.
If it is a numeric value you should use num(Max(Month),'00')
Regards,
Kaushik Solanki
Hi,
This depends on what data format you have in Month field.
If it is a Text then you should use the Maxstring instead of Max function.
If it is a numeric value you should use num(Max(Month),'00')
Regards,
Kaushik Solanki
This is right: num(Max(Month),'00')
Where can I see format of Fields?
The Easy option is, add the filter on sheet and observe the data, if it is on left side it is text else it is number.
Regards,
Kaushik Solanki