Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Is it possible to use the Msgbox function in the expression in Straight or Piviot table.
for ex:
=if(a< b, sum(CID),Msgbox("A should be less than b"))
Regards,XXX
Instead of using a message box, you can use the calculation condition to highlight the required text when the calculation condition is not satisfied. Use the below expression in the 'Calculation Condition' property under the 'General' tab
=if(a< b, true(),false())
The required error message can be entered by using the 'Error Messages' button in the 'General' tab.
Instead of using a message box, you can use the calculation condition to highlight the required text when the calculation condition is not satisfied. Use the below expression in the 'Calculation Condition' property under the 'General' tab
=if(a< b, true(),false())
The required error message can be entered by using the 'Error Messages' button in the 'General' tab.